Notes

activate virtual env

source venv/bin/activate

Load env variables in session:

set -a && source .env && set +a && dbt parse

Generate schema name macro override

The default behaviour: dbt adds the default schema name defined in profiles.yml before the schema name. if we want to load data in raw_stage as defined in dbt_project.yml, and our default schema defined in public, then dbt will try to load the data to public_raw_stage schema. To override, add a macro.

Load data from olist_orders.csv file in seeds folder to database

dbt seed --select olist_orders it infers the schema from the data in the csv file automatically, or you can define the schema for seeds in dbt_project.yml under seeds. The name of the csv file is what will be the name of the database table.

Run a model stg_orders to load data

dbt run --select stg_orders