Skip to content

Instantly share code, notes, and snippets.

@MaxHalford
Created November 29, 2022 23:12
Show Gist options
  • Save MaxHalford/2bfa9863c18af12d286f233a8f36f28e to your computer and use it in GitHub Desktop.
Save MaxHalford/2bfa9863c18af12d286f233a8f36f28e to your computer and use it in GitHub Desktop.
Local DuckDB setup
project:
outputs:
prod:
type: duckdb
path: /tmp/project.duckdb
target: prod
dbt-duckdb
duckdb
pandas
pyarrow
dbt init project
cd project
python -m venv .venv
source .venv/bin/activate
pip install --upgrade pip
pip install -r requirements.txt
ln -s "$PWD/profiles.yml" ~/.dbt/profiles.yml
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment