Skip to content

Instantly share code, notes, and snippets.

@jgdwyer
jgdwyer / dbt_demo.md
Created October 26, 2021 03:10
Set up instructions for dbt demo data in Snowflake data warehouse
  1. 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.
  2. 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;
  1. Install dbt following the instructions here. I recommend installing dbt with pip into a Python virtual environment.
pip install dbt