Transforming Data with dbt

Dimensional Modeling and Slowly Changing Dimensions built BookNest's star with hand-run, untested scripts that had to run in the right order. dbt 37,942 turns them into a project that orders, builds, tests and documents itself. This section rebuilds the star in demos/ch04/dbt/ on PostgreSQL 18 1,289 and DuckDB 61,228 , ready for Orchestration and Pipelines to schedule.

Subsections

• What dbt Does
• Project Setup and Profiles
• Sources and Freshness
• Models and ref()
• dbt Materializations
• Incremental Models
• Generic and Singular Tests
• Snapshots
• Docs and Lineage Graph