Editor's top dbt books
2Analytics Engineering with SQL and dbt
Rui Machado, Hélder Russa · O'Reilly · 324 pages · ~8 hrs to read
The most comprehensive dbt book — covers the full analytics engineering workflow from data modelling through dbt transformations, testing, documentation, and CI/CD. The standard reference for professionals learning dbt.
Data Engineering with dbt
Roberto Zagni · Packt · 578 pages · ~14 hrs to read
Walks through building a full dbt Cloud project on Snowflake and GitHub with real CI/CD — dimensional modeling styles (Kimball, Data Vault, Unified Star Schema), writing maintainable dbt code, and automated testing and deployment. The most complete single book on doing dbt properly in production.
dbt Books for Beginners
1Fundamentals of Analytics Engineering
Dumky de Wilde, Fanny Kassapian, Jovan Gligorevic, Juan Manuel Perafan, Lasse Benninga, Ricardo Angel Granados Lopez, Taís Laurindo Pereira · Packt · 332 pages · ~8 hrs to read
Seven analytics engineering practitioners walk through an entire pipeline — ingestion with Airbyte, transformation with dbt, warehousing in BigQuery, and visualization in Tableau — giving dbt proper context inside the modern data stack.
Intermediate & Advanced dbt Books
9Analytics Engineering with SQL and dbt
Rui Machado, Hélder Russa · O'Reilly · 324 pages · ~8 hrs to read
The most comprehensive dbt book — covers the full analytics engineering workflow from data modelling through dbt transformations, testing, documentation, and CI/CD. The standard reference for professionals learning dbt.
Data Pipelines Pocket Reference
James Densmore · O'Reilly · 180 pages · ~5 hrs to read
Covers dbt as part of a complete data pipeline stack — useful context for data engineers who want to understand how dbt fits with ingestion, orchestration, and warehousing in real pipeline architectures.
Fundamentals of Data Engineering
Joe Reis, Matt Housley · O'Reilly · 446 pages · ~11 hrs to read
The canonical data engineering reference — positions dbt within the transformation stage of the data engineering lifecycle and explains when and why to use it. Essential for understanding dbt's role in the broader stack.
Data Engineering with dbt
Roberto Zagni · Packt · 578 pages · ~14 hrs to read
Walks through building a full dbt Cloud project on Snowflake and GitHub with real CI/CD — dimensional modeling styles (Kimball, Data Vault, Unified Star Schema), writing maintainable dbt code, and automated testing and deployment. The most complete single book on doing dbt properly in production.
Building a Pragmatic Data Platform with dbt and Snowflake
Roberto Zagni & Jakob Brandel0
A follow-up to Zagni's first dbt book aimed at data architects and technical leads designing the platform, not just writing models — where dbt fits relative to ingestion, orchestration, and governance for a full Snowflake-based stack.
The Data Warehouse Toolkit, 3rd Edition
Ralph Kimball & Margy Ross · Wiley · 608 pages · ~15 hrs to read
The foundational text on dimensional modeling — star schemas, slowly changing dimensions, fact table grain — that predates dbt but defines the vocabulary (staging, dims, facts, marts) most dbt projects are structured around.
Deciphering Data Architectures
James Serra · O'Reilly · 262 pages · ~7 hrs to read
Written by a Microsoft data architect, this explains when a modern data warehouse (the pattern dbt is built for) is the right choice versus a lakehouse, data mesh, or data fabric.
Data Modeling with Snowflake
Serge Gershkovich · Packt · 324 pages · ~8 hrs to read
Covers Star Schema and Data Vault modeling techniques specifically for cloud warehouses like Snowflake, the database dbt is most commonly paired with — directly useful for structuring the staging-to-mart layering dbt projects depend on.
Agile Data Warehouse Design
Lawrence Corr & Jim Stagnitto · 330 pages · ~8 hrs to read
Introduces BEAM, a collaborative, whiteboard-first approach to dimensional modeling that pairs well with dbt's iterative, version-controlled workflow — useful for running requirements sessions with business stakeholders before writing a model.
dbt resources
Learn next