sample-dbt

A starter for setting up dbt test cases.

Requirements:

• Docker
• dbt
• Python

Getting started

Unless otherwise specified, run all commands from the repo root.

1. Set up Postgres and populate the pagila sample database.

   ./setup-postgres.sh

2. Set up dbt (order matters!):

   # create ~/.dbt directory to copy profiles.yml
   mkdir ~/.dbt
   # copy profiles.yml to ~/.dbt/
   cp profiles.yml ~/.dbt/

3. Generate files for dbt:

   ./generate.sh