dbt

Medallion Architecture

• https://i-spark.nl/en/blog/dbt-naming-conventions-and-medallion-architecture/
• https://sqlpatterns.com/p/designing-an-evolutionary-data-architecture

Basics

export DBT_PROFILE_DIR=$(pwd)/profiles
dbt init <project_name> --profiles-dir=$DBT_PROFILE_DIR
export DBT_PROJECT_DIR=$(pwd)/projects/<project_name>
dbt debug --profiles-dir=$DBT_PROFILE_DIR
dbt run --profiles-dir=$DBT_PROFILE_DIR --target dev
dbt seed --profiles-dir=$DBT_PROFILE_DIR
dbt test --profiles-dir=$DBT_PROFILE_DIR
dbt docs generate --profiles-dir=$DBT_PROFILE_DIR
dbt docs serve --profiles-dir=$DBT_PROFILE_DIR --host 0.0.0.0 --port 8080

Studies

• Study Postgres
• Study Sqlite
• Study Mart
• Study Macro
• Study Dagster
• Study Test

References

• https://www.getdbt.com/