Self: DBT

Self Sandbox that implement with the best practice of DBT project.

Note

I will implement duckdb and dbt with dbt-duckdb package.

Note

It's not an engine like Spark; it's not a database like Postgres or Snowflake; it's a tool that helps you manage your SQL data transformation.

Prerequisite

Initial

dbt init lakehouse --profiles-dir . --project-dir .
ls -al ./lakehouse

Build & Run

dbt build --project-dir ./lakehouse --profiles-dir ./lakehouse
dbt run --project-dir ./lakehouse --profiles-dir ./lakehouse

Compile

dbt compile --inline "select * from {{ ref('demo_model') }}" --project-dir ./lakehouse --profiles-dir ./lakehouse