- This will require a connection to a database. For this demo, I'll be using a Snowflake trial account. You can sign up for that here (no credit card required). You can also use a different database like postgresql. But configuration in later steps will be different.
- Create a new database and schema. For Snowflake you can run:
create database if not exists jaffle_shop;
create schema if not exists jaffle_shop.dbt_demo;
- Install dbt following the instructions here. I recommend installing dbt with pip into a Python virtual environment.
pip install dbt
- Clone the dbt jaffle_shop repo locally and change to the new directory
git clone https://github.com/dbt-labs/jaffle_shop.git
cd jaffle_shop
- Create a new
profiles.yml
file in your ~/.dbt/
directory
jaffle_shop:
target: dev
outputs:
dev:
type: snowflake
account: <ACCOUNTNAME>
user: <USERNAME>
password: <PASSWORD>
database: jaffle_shop
warehouse: compute_wh
schema: dbt_demo
- Run
dbt debug
to confirm that everything is set up. If it passes, you are good to go!