dbt-postgres

This project creates a Postgres server and a database, Paglia.
Dbt is being used to create 3 models: base, staging and final.
the final model uses a macro to calculate taxes.
To calculate taxes, the macro calculate_tax was created
Also, a seed is included with Covid-19 data from us counties.

How to run?

Database

Install Docker

Inside ./dbt-postgres, run:

 docker-compose  up -d 

The code above will create a Postgre container and load the database

DBT

Install dbt:

pip install dbt-postgres

Run DBT models:

dbt run

Run seed:

dbt seed