- 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