hsheth2/sample-dbt

PLpgSQL

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.

Set up Postgres and populate the pagila sample database.
```
./setup-postgres.sh
```

Set up dbt (order matters!):

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

Generate files for dbt:
```
./generate.sh
```