dbt Defer Explained: How to Use --defer with a Practical Example
Learn how dbt --defer works with a practical dim_student example using --state, a production manifest, and upstream model references.
dbt
This page contains hands-on dbt (Data Build Tool) tutorials. dbt is a powerful open-source technology that enables teams to transform raw data into valuable insights through SQL-based workflows. Here you will find hands-on tutorials and best practices for using dbt effectively. Our dbt tutorials also serve as a resource for anyone preparing for dbt Analytics Engineering Certification Exam.
66 posts
dbt Incremental Models Explained with a Practical Example
Learn dbt incremental models with a practical enrollment_cleaned example using materialized incremental, unique_key, is_incremental(), updated_at, and data tests.
How to Build Fact and Dimension Tables in dbt
Learn how to build business-ready fact and dimension tables in dbt using a simple Gold layer example with dim_course, dim_student, and fact_enrollment.
Why Codex Is a Productivity Booster for Data Engineers
Learn why Codex can make Data Engineers more productive by helping with dbt YAML, column descriptions, SQL reviews, debugging, boilerplate, and project conventions.
How to Use Codex to Create dbt Models
Learn how to use Codex to create a dbt Gold model from existing Silver models with clear prompts, dbt ref(), YAML tests, and a practical review workflow.
How to Connect Claude Desktop to Your dbt Project with MCP
Learn how to connect Claude Desktop to a local dbt project with the official dbt MCP server and safe dbt CLI access.
dbt Snapshots Explained: Track Historical Changes in Your Data Warehouse
Learn what dbt snapshots are, why they matter, and how to track historical changes in your data warehouse with a beginner-friendly customer status example.
dbt Exposures Explained for Beginners: Connect Models to Dashboards, Reports, and ML Models
Learn what dbt exposures are, why they matter, and how to connect dbt models to dashboards, reports, notebooks, and machine learning workflows.
dlt vs dbt: What is the Difference?
📘 Introduction When you start learning modern data pipelines, you will quickly hear about both dlt and dbt. The names look similar, and both tools are used in data engineering workflows. But they solve different problems. In this beginner-friendly guide, we will explain the difference between dlt and dbt, where each...