Curriculum planned

Stage 09 · Integration, CDC & Orchestration

dbt Core

A comprehensive dbt Core course covering analytics engineering, project structure, models and ref/source graphs, materializations, incremental and microbatch processing, tests, snapshots, seeds, macros/Jinja, packages, documentation, contracts, model versions, state/defer, artifacts, adapters, CI/CD, security, performance, governance, semantic-layer awareness, and dbt Core 2.0/Fusion migration planning.

Browse planned curriculum Back to all courses

36planned chapters

180reserved lesson paths

Intermediate → Advancedlearning level

Plannedcourse state

Coverage baselinedbt Core 1.11.x stable production baseline with awareness of the dbt Core 2.0/Fusion Rust rewrite in alpha during mid-2026; coverage includes models, materializations, tests, snapshots, sources, macros/Jinja, packages, contracts, versions, incremental/microbatch patterns, state/defer, exposures/metrics awareness, artifacts, CI, governance, and migration planning

Course brief

Build trustworthy transformation projects by making SQL dependency graphs, model contracts, tests, source freshness, incremental state, documentation, deployment environments, and change control explicit—then treat the warehouse and adapter as part of the execution model rather than hiding them behind dbt.

A comprehensive dbt Core course covering analytics engineering, project structure, models and ref/source graphs, materializations, incremental and microbatch processing, tests, snapshots, seeds, macros/Jinja, packages, documentation, contracts, model versions, state/defer, artifacts, adapters, CI/CD, security, performance, governance, semantic-layer awareness, and dbt Core 2.0/Fusion migration planning.

This syllabus deliberately separates foundations, data/model semantics, internals, reliability, security, performance, operations, and production design so advanced material is not compressed into generic catch-all chapters.

By the end

You will be able to

Build modular dbt projects with sources, staging/intermediate/mart layers, ref/source dependencies, reusable macros, packages, tests, documentation, and explicit contracts
Choose and tune view/table/incremental/ephemeral/custom materializations including merge, insert-overwrite, microbatch, partitioning, clustering, and warehouse-specific behavior
Use snapshots, freshness, state selection, defer, slim CI, model versions, access rules, exposures/metrics awareness, and artifacts to govern change safely
Debug compilation and runtime behavior using manifests, run results, compiled SQL, logs, query plans, adapter behavior, warehouse metrics, and deterministic test data
Operate dbt Core in CI/CD and production with secrets, environment promotion, orchestration, package pinning, migration gates, and a clear path from 1.11 to future 2.0/Fusion capabilities

Complete planned syllabus

36 chapters · 180 lesson paths.

Every lesson path is reserved now but intentionally not linked until its lesson HTML is actually published. The sequence moves from foundations through advanced implementation, architecture, operations, reliability, security, tuning, and a production capstone.

01

Chapter 1

dbt Foundations: Analytics Engineering, ELT, dbt Core 1.11.x, Project Mental Model, Warehouse Responsibilities, and Local Lab Setup

5 lessons

01

dbt Foundations: Analytics Engineering, ELT, dbt Core 1.11.x, Project Mental Model, Warehouse Responsibilities, and Local Lab Setup: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter01/Lesson1.html

Planned02

dbt Foundations: Analytics Engineering, ELT, dbt Core 1.11.x, Project Mental Model, Warehouse Responsibilities, and Local Lab Setup: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter01/Lesson2.html

Planned03

dbt Foundations: Analytics Engineering, ELT, dbt Core 1.11.x, Project Mental Model, Warehouse Responsibilities, and Local Lab Setup: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter01/Lesson3.html

Planned04

dbt Foundations: Analytics Engineering, ELT, dbt Core 1.11.x, Project Mental Model, Warehouse Responsibilities, and Local Lab Setup: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter01/Lesson4.html

Planned05

Checkpoint Lab — dbt Foundations: Analytics Engineering, ELT, dbt Core 1.11.x, Project Mental Model, Warehouse Responsibilities, and Local Lab Setup: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter01/Lesson5.html

Planned

02

Chapter 2

Installation and Profiles: Python Environments, dbt Core/Adapter Packages, profiles.yml, Targets, Credentials, Environment Variables, and Reproducibility

5 lessons

01

Installation and Profiles: Python Environments, dbt Core/Adapter Packages, profiles.yml, Targets, Credentials, Environment Variables, and Reproducibility: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter02/Lesson1.html

Planned02

Installation and Profiles: Python Environments, dbt Core/Adapter Packages, profiles.yml, Targets, Credentials, Environment Variables, and Reproducibility: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter02/Lesson2.html

Planned03

Installation and Profiles: Python Environments, dbt Core/Adapter Packages, profiles.yml, Targets, Credentials, Environment Variables, and Reproducibility: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter02/Lesson3.html

Planned04

Installation and Profiles: Python Environments, dbt Core/Adapter Packages, profiles.yml, Targets, Credentials, Environment Variables, and Reproducibility: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter02/Lesson4.html

Planned05

Checkpoint Lab — Installation and Profiles: Python Environments, dbt Core/Adapter Packages, profiles.yml, Targets, Credentials, Environment Variables, and Reproducibility: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter02/Lesson5.html

Planned

03

Chapter 3

Project Structure: dbt_project.yml, Model Paths, Seeds, Snapshots, Macros, Tests, Analyses, Documentation, and Naming Conventions

5 lessons

01

Project Structure: dbt_project.yml, Model Paths, Seeds, Snapshots, Macros, Tests, Analyses, Documentation, and Naming Conventions: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter03/Lesson1.html

Planned02

Project Structure: dbt_project.yml, Model Paths, Seeds, Snapshots, Macros, Tests, Analyses, Documentation, and Naming Conventions: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter03/Lesson2.html

Planned03

Project Structure: dbt_project.yml, Model Paths, Seeds, Snapshots, Macros, Tests, Analyses, Documentation, and Naming Conventions: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter03/Lesson3.html

Planned04

Project Structure: dbt_project.yml, Model Paths, Seeds, Snapshots, Macros, Tests, Analyses, Documentation, and Naming Conventions: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter03/Lesson4.html

Planned05

Checkpoint Lab — Project Structure: dbt_project.yml, Model Paths, Seeds, Snapshots, Macros, Tests, Analyses, Documentation, and Naming Conventions: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter03/Lesson5.html

Planned

04

Chapter 4

Models and DAG Construction: SELECT-Based Models, ref(), source(), Dependency Graphs, Compilation, Selection, and Build Order

5 lessons

01

Models and DAG Construction: SELECT-Based Models, ref(), source(), Dependency Graphs, Compilation, Selection, and Build Order: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter04/Lesson1.html

Planned02

Models and DAG Construction: SELECT-Based Models, ref(), source(), Dependency Graphs, Compilation, Selection, and Build Order: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter04/Lesson2.html

Planned03

Models and DAG Construction: SELECT-Based Models, ref(), source(), Dependency Graphs, Compilation, Selection, and Build Order: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter04/Lesson3.html

Planned04

Models and DAG Construction: SELECT-Based Models, ref(), source(), Dependency Graphs, Compilation, Selection, and Build Order: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter04/Lesson4.html

Planned05

Checkpoint Lab — Models and DAG Construction: SELECT-Based Models, ref(), source(), Dependency Graphs, Compilation, Selection, and Build Order: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter04/Lesson5.html

Planned

05

Chapter 5

Sources: Source Definitions, Tables, Descriptions, Freshness, Loaded-At Fields, Quoting, Database/Schema Mapping, and Source Contracts

5 lessons

01

Sources: Source Definitions, Tables, Descriptions, Freshness, Loaded-At Fields, Quoting, Database/Schema Mapping, and Source Contracts: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter05/Lesson1.html

Planned02

Sources: Source Definitions, Tables, Descriptions, Freshness, Loaded-At Fields, Quoting, Database/Schema Mapping, and Source Contracts: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter05/Lesson2.html

Planned03

Sources: Source Definitions, Tables, Descriptions, Freshness, Loaded-At Fields, Quoting, Database/Schema Mapping, and Source Contracts: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter05/Lesson3.html

Planned04

Sources: Source Definitions, Tables, Descriptions, Freshness, Loaded-At Fields, Quoting, Database/Schema Mapping, and Source Contracts: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter05/Lesson4.html

Planned05

Checkpoint Lab — Sources: Source Definitions, Tables, Descriptions, Freshness, Loaded-At Fields, Quoting, Database/Schema Mapping, and Source Contracts: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter05/Lesson5.html

Planned

06

Chapter 6

Staging, Intermediate, and Marts: Layered Modeling, Naming, Grain, Reusability, Dimensional Patterns, and Avoiding Monolithic SQL

5 lessons

01

Staging, Intermediate, and Marts: Layered Modeling, Naming, Grain, Reusability, Dimensional Patterns, and Avoiding Monolithic SQL: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter06/Lesson1.html

Planned02

Staging, Intermediate, and Marts: Layered Modeling, Naming, Grain, Reusability, Dimensional Patterns, and Avoiding Monolithic SQL: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter06/Lesson2.html

Planned03

Staging, Intermediate, and Marts: Layered Modeling, Naming, Grain, Reusability, Dimensional Patterns, and Avoiding Monolithic SQL: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter06/Lesson3.html

Planned04

Staging, Intermediate, and Marts: Layered Modeling, Naming, Grain, Reusability, Dimensional Patterns, and Avoiding Monolithic SQL: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter06/Lesson4.html

Planned05

Checkpoint Lab — Staging, Intermediate, and Marts: Layered Modeling, Naming, Grain, Reusability, Dimensional Patterns, and Avoiding Monolithic SQL: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter06/Lesson5.html

Planned

07

Chapter 7

Materializations: View, Table, Ephemeral, Incremental, Custom Materializations, Adapter Dispatch, and Cost/Performance Tradeoffs

5 lessons

01

Materializations: View, Table, Ephemeral, Incremental, Custom Materializations, Adapter Dispatch, and Cost/Performance Tradeoffs: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter07/Lesson1.html

Planned02

Materializations: View, Table, Ephemeral, Incremental, Custom Materializations, Adapter Dispatch, and Cost/Performance Tradeoffs: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter07/Lesson2.html

Planned03

Materializations: View, Table, Ephemeral, Incremental, Custom Materializations, Adapter Dispatch, and Cost/Performance Tradeoffs: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter07/Lesson3.html

Planned04

Materializations: View, Table, Ephemeral, Incremental, Custom Materializations, Adapter Dispatch, and Cost/Performance Tradeoffs: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter07/Lesson4.html

Planned05

Checkpoint Lab — Materializations: View, Table, Ephemeral, Incremental, Custom Materializations, Adapter Dispatch, and Cost/Performance Tradeoffs: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter07/Lesson5.html

Planned

08

Chapter 8

Incremental Models: is_incremental(), unique_key, Merge Strategies, Insert-Overwrite, Delete/Insert, Predicates, Late Data, and Full Refresh

5 lessons

01

Incremental Models: is_incremental(), unique_key, Merge Strategies, Insert-Overwrite, Delete/Insert, Predicates, Late Data, and Full Refresh: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter08/Lesson1.html

Planned02

Incremental Models: is_incremental(), unique_key, Merge Strategies, Insert-Overwrite, Delete/Insert, Predicates, Late Data, and Full Refresh: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter08/Lesson2.html

Planned03

Incremental Models: is_incremental(), unique_key, Merge Strategies, Insert-Overwrite, Delete/Insert, Predicates, Late Data, and Full Refresh: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter08/Lesson3.html

Planned04

Incremental Models: is_incremental(), unique_key, Merge Strategies, Insert-Overwrite, Delete/Insert, Predicates, Late Data, and Full Refresh: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter08/Lesson4.html

Planned05

Checkpoint Lab — Incremental Models: is_incremental(), unique_key, Merge Strategies, Insert-Overwrite, Delete/Insert, Predicates, Late Data, and Full Refresh: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter08/Lesson5.html

Planned

09

Chapter 9

Microbatch Incremental Models: Event-Time Configuration, Batch Windows, Lookback, Parallelism Concepts, Retry Semantics, and Time-Based Backfills

5 lessons

01

Microbatch Incremental Models: Event-Time Configuration, Batch Windows, Lookback, Parallelism Concepts, Retry Semantics, and Time-Based Backfills: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter09/Lesson1.html

Planned02

Microbatch Incremental Models: Event-Time Configuration, Batch Windows, Lookback, Parallelism Concepts, Retry Semantics, and Time-Based Backfills: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter09/Lesson2.html

Planned03

Microbatch Incremental Models: Event-Time Configuration, Batch Windows, Lookback, Parallelism Concepts, Retry Semantics, and Time-Based Backfills: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter09/Lesson3.html

Planned04

Microbatch Incremental Models: Event-Time Configuration, Batch Windows, Lookback, Parallelism Concepts, Retry Semantics, and Time-Based Backfills: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter09/Lesson4.html

Planned05

Checkpoint Lab — Microbatch Incremental Models: Event-Time Configuration, Batch Windows, Lookback, Parallelism Concepts, Retry Semantics, and Time-Based Backfills: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter09/Lesson5.html

Planned

10

Chapter 10

Jinja Fundamentals: Expressions, Statements, Variables, Loops, Conditionals, Whitespace, Context, Compilation-Time vs Warehouse-Time Logic

5 lessons

01

Jinja Fundamentals: Expressions, Statements, Variables, Loops, Conditionals, Whitespace, Context, Compilation-Time vs Warehouse-Time Logic: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter10/Lesson1.html

Planned02

Jinja Fundamentals: Expressions, Statements, Variables, Loops, Conditionals, Whitespace, Context, Compilation-Time vs Warehouse-Time Logic: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter10/Lesson2.html

Planned03

Jinja Fundamentals: Expressions, Statements, Variables, Loops, Conditionals, Whitespace, Context, Compilation-Time vs Warehouse-Time Logic: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter10/Lesson3.html

Planned04

Jinja Fundamentals: Expressions, Statements, Variables, Loops, Conditionals, Whitespace, Context, Compilation-Time vs Warehouse-Time Logic: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter10/Lesson4.html

Planned05

Checkpoint Lab — Jinja Fundamentals: Expressions, Statements, Variables, Loops, Conditionals, Whitespace, Context, Compilation-Time vs Warehouse-Time Logic: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter10/Lesson5.html

Planned

11

Chapter 11

Macros: Macro Design, Arguments, Return Values, execute Guard, run_query, Logging, Exceptions, Reuse, Namespacing, and API Stability

5 lessons

01

Macros: Macro Design, Arguments, Return Values, execute Guard, run_query, Logging, Exceptions, Reuse, Namespacing, and API Stability: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter11/Lesson1.html

Planned02

Macros: Macro Design, Arguments, Return Values, execute Guard, run_query, Logging, Exceptions, Reuse, Namespacing, and API Stability: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter11/Lesson2.html

Planned03

Macros: Macro Design, Arguments, Return Values, execute Guard, run_query, Logging, Exceptions, Reuse, Namespacing, and API Stability: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter11/Lesson3.html

Planned04

Macros: Macro Design, Arguments, Return Values, execute Guard, run_query, Logging, Exceptions, Reuse, Namespacing, and API Stability: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter11/Lesson4.html

Planned05

Checkpoint Lab — Macros: Macro Design, Arguments, Return Values, execute Guard, run_query, Logging, Exceptions, Reuse, Namespacing, and API Stability: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter11/Lesson5.html

Planned

12

Chapter 12

Adapter Dispatch and Cross-Warehouse SQL: dispatch(), Adapter Macros, Capability Differences, Type Handling, Quoting, and Portability Boundaries

5 lessons

01

Adapter Dispatch and Cross-Warehouse SQL: dispatch(), Adapter Macros, Capability Differences, Type Handling, Quoting, and Portability Boundaries: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter12/Lesson1.html

Planned02

Adapter Dispatch and Cross-Warehouse SQL: dispatch(), Adapter Macros, Capability Differences, Type Handling, Quoting, and Portability Boundaries: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter12/Lesson2.html

Planned03

Adapter Dispatch and Cross-Warehouse SQL: dispatch(), Adapter Macros, Capability Differences, Type Handling, Quoting, and Portability Boundaries: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter12/Lesson3.html

Planned04

Adapter Dispatch and Cross-Warehouse SQL: dispatch(), Adapter Macros, Capability Differences, Type Handling, Quoting, and Portability Boundaries: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter12/Lesson4.html

Planned05

Checkpoint Lab — Adapter Dispatch and Cross-Warehouse SQL: dispatch(), Adapter Macros, Capability Differences, Type Handling, Quoting, and Portability Boundaries: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter12/Lesson5.html

Planned

13

Chapter 13

Generic and Singular Data Tests: not_null, unique, relationships, accepted_values, Custom Tests, Severity, where, store_failures, and Test Design

5 lessons

01

Generic and Singular Data Tests: not_null, unique, relationships, accepted_values, Custom Tests, Severity, where, store_failures, and Test Design: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter13/Lesson1.html

Planned02

Generic and Singular Data Tests: not_null, unique, relationships, accepted_values, Custom Tests, Severity, where, store_failures, and Test Design: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter13/Lesson2.html

Planned03

Generic and Singular Data Tests: not_null, unique, relationships, accepted_values, Custom Tests, Severity, where, store_failures, and Test Design: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter13/Lesson3.html

Planned04

Generic and Singular Data Tests: not_null, unique, relationships, accepted_values, Custom Tests, Severity, where, store_failures, and Test Design: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter13/Lesson4.html

Planned05

Checkpoint Lab — Generic and Singular Data Tests: not_null, unique, relationships, accepted_values, Custom Tests, Severity, where, store_failures, and Test Design: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter13/Lesson5.html

Planned

14

Chapter 14

Unit Tests: Fixtures, Inputs/Expected Rows, Mocked Refs/Sources, Versioned Models, Incremental Logic, Determinism, and Appropriate Test Scope

5 lessons

01

Unit Tests: Fixtures, Inputs/Expected Rows, Mocked Refs/Sources, Versioned Models, Incremental Logic, Determinism, and Appropriate Test Scope: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter14/Lesson1.html

Planned02

Unit Tests: Fixtures, Inputs/Expected Rows, Mocked Refs/Sources, Versioned Models, Incremental Logic, Determinism, and Appropriate Test Scope: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter14/Lesson2.html

Planned03

Unit Tests: Fixtures, Inputs/Expected Rows, Mocked Refs/Sources, Versioned Models, Incremental Logic, Determinism, and Appropriate Test Scope: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter14/Lesson3.html

Planned04

Unit Tests: Fixtures, Inputs/Expected Rows, Mocked Refs/Sources, Versioned Models, Incremental Logic, Determinism, and Appropriate Test Scope: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter14/Lesson4.html

Planned05

Checkpoint Lab — Unit Tests: Fixtures, Inputs/Expected Rows, Mocked Refs/Sources, Versioned Models, Incremental Logic, Determinism, and Appropriate Test Scope: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter14/Lesson5.html

Planned

15

Chapter 15

Model Contracts and Constraints: Enforced Schemas, Data Types, Constraints, Contract Changes, Compatibility, and Deployment Safety

5 lessons

01

Model Contracts and Constraints: Enforced Schemas, Data Types, Constraints, Contract Changes, Compatibility, and Deployment Safety: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter15/Lesson1.html

Planned02

Model Contracts and Constraints: Enforced Schemas, Data Types, Constraints, Contract Changes, Compatibility, and Deployment Safety: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter15/Lesson2.html

Planned03

Model Contracts and Constraints: Enforced Schemas, Data Types, Constraints, Contract Changes, Compatibility, and Deployment Safety: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter15/Lesson3.html

Planned04

Model Contracts and Constraints: Enforced Schemas, Data Types, Constraints, Contract Changes, Compatibility, and Deployment Safety: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter15/Lesson4.html

Planned05

Checkpoint Lab — Model Contracts and Constraints: Enforced Schemas, Data Types, Constraints, Contract Changes, Compatibility, and Deployment Safety: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter15/Lesson5.html

Planned

16

Chapter 16

Model Versions and Access: latest_version, Versioned Refs, Deprecation Dates, Access Levels, Groups, Breaking Changes, and Consumer Migration

5 lessons

01

Model Versions and Access: latest_version, Versioned Refs, Deprecation Dates, Access Levels, Groups, Breaking Changes, and Consumer Migration: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter16/Lesson1.html

Planned02

Model Versions and Access: latest_version, Versioned Refs, Deprecation Dates, Access Levels, Groups, Breaking Changes, and Consumer Migration: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter16/Lesson2.html

Planned03

Model Versions and Access: latest_version, Versioned Refs, Deprecation Dates, Access Levels, Groups, Breaking Changes, and Consumer Migration: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter16/Lesson3.html

Planned04

Model Versions and Access: latest_version, Versioned Refs, Deprecation Dates, Access Levels, Groups, Breaking Changes, and Consumer Migration: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter16/Lesson4.html

Planned05

Checkpoint Lab — Model Versions and Access: latest_version, Versioned Refs, Deprecation Dates, Access Levels, Groups, Breaking Changes, and Consumer Migration: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter16/Lesson5.html

Planned

17

Chapter 17

Snapshots: SCD Type 2, Timestamp/Check Strategies, Hard Deletes, Unique Keys, Target Schemas, History Semantics, and Snapshot Maintenance

5 lessons

01

Snapshots: SCD Type 2, Timestamp/Check Strategies, Hard Deletes, Unique Keys, Target Schemas, History Semantics, and Snapshot Maintenance: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter17/Lesson1.html

Planned02

Snapshots: SCD Type 2, Timestamp/Check Strategies, Hard Deletes, Unique Keys, Target Schemas, History Semantics, and Snapshot Maintenance: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter17/Lesson2.html

Planned03

Snapshots: SCD Type 2, Timestamp/Check Strategies, Hard Deletes, Unique Keys, Target Schemas, History Semantics, and Snapshot Maintenance: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter17/Lesson3.html

Planned04

Snapshots: SCD Type 2, Timestamp/Check Strategies, Hard Deletes, Unique Keys, Target Schemas, History Semantics, and Snapshot Maintenance: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter17/Lesson4.html

Planned05

Checkpoint Lab — Snapshots: SCD Type 2, Timestamp/Check Strategies, Hard Deletes, Unique Keys, Target Schemas, History Semantics, and Snapshot Maintenance: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter17/Lesson5.html

Planned

18

Chapter 18

Seeds and Static Reference Data: CSV Seeds, Types, Delimiters, Version Control, Large-Seed Limits, Environment Differences, and Alternatives

5 lessons

01

Seeds and Static Reference Data: CSV Seeds, Types, Delimiters, Version Control, Large-Seed Limits, Environment Differences, and Alternatives: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter18/Lesson1.html

Planned02

Seeds and Static Reference Data: CSV Seeds, Types, Delimiters, Version Control, Large-Seed Limits, Environment Differences, and Alternatives: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter18/Lesson2.html

Planned03

Seeds and Static Reference Data: CSV Seeds, Types, Delimiters, Version Control, Large-Seed Limits, Environment Differences, and Alternatives: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter18/Lesson3.html

Planned04

Seeds and Static Reference Data: CSV Seeds, Types, Delimiters, Version Control, Large-Seed Limits, Environment Differences, and Alternatives: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter18/Lesson4.html

Planned05

Checkpoint Lab — Seeds and Static Reference Data: CSV Seeds, Types, Delimiters, Version Control, Large-Seed Limits, Environment Differences, and Alternatives: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter18/Lesson5.html

Planned

19

Chapter 19

Packages and Dependencies: packages.yml/dependencies.yml Concepts, Package Hubs/Git, Version Pinning, Macro Namespace Collisions, and Supply-Chain Hygiene

5 lessons

01

Packages and Dependencies: packages.yml/dependencies.yml Concepts, Package Hubs/Git, Version Pinning, Macro Namespace Collisions, and Supply-Chain Hygiene: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter19/Lesson1.html

Planned02

Packages and Dependencies: packages.yml/dependencies.yml Concepts, Package Hubs/Git, Version Pinning, Macro Namespace Collisions, and Supply-Chain Hygiene: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter19/Lesson2.html

Planned03

Packages and Dependencies: packages.yml/dependencies.yml Concepts, Package Hubs/Git, Version Pinning, Macro Namespace Collisions, and Supply-Chain Hygiene: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter19/Lesson3.html

Planned04

Packages and Dependencies: packages.yml/dependencies.yml Concepts, Package Hubs/Git, Version Pinning, Macro Namespace Collisions, and Supply-Chain Hygiene: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter19/Lesson4.html

Planned05

Checkpoint Lab — Packages and Dependencies: packages.yml/dependencies.yml Concepts, Package Hubs/Git, Version Pinning, Macro Namespace Collisions, and Supply-Chain Hygiene: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter19/Lesson5.html

Planned

20

Chapter 20

Documentation and Lineage: Descriptions, docs Blocks, dbt docs, Catalog Metadata, Lineage Graphs, Column Documentation, and Ownership

5 lessons

01

Documentation and Lineage: Descriptions, docs Blocks, dbt docs, Catalog Metadata, Lineage Graphs, Column Documentation, and Ownership: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter20/Lesson1.html

Planned02

Documentation and Lineage: Descriptions, docs Blocks, dbt docs, Catalog Metadata, Lineage Graphs, Column Documentation, and Ownership: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter20/Lesson2.html

Planned03

Documentation and Lineage: Descriptions, docs Blocks, dbt docs, Catalog Metadata, Lineage Graphs, Column Documentation, and Ownership: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter20/Lesson3.html

Planned04

Documentation and Lineage: Descriptions, docs Blocks, dbt docs, Catalog Metadata, Lineage Graphs, Column Documentation, and Ownership: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter20/Lesson4.html

Planned05

Checkpoint Lab — Documentation and Lineage: Descriptions, docs Blocks, dbt docs, Catalog Metadata, Lineage Graphs, Column Documentation, and Ownership: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter20/Lesson5.html

Planned

21

Chapter 21

Exposures, Groups, Metrics, and Semantic-Layer Awareness: Downstream Consumers, Ownership, Maturity, Semantic Models, Metric Definitions, and Scope Boundaries

5 lessons

01

Exposures, Groups, Metrics, and Semantic-Layer Awareness: Downstream Consumers, Ownership, Maturity, Semantic Models, Metric Definitions, and Scope Boundaries: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter21/Lesson1.html

Planned02

Exposures, Groups, Metrics, and Semantic-Layer Awareness: Downstream Consumers, Ownership, Maturity, Semantic Models, Metric Definitions, and Scope Boundaries: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter21/Lesson2.html

Planned03

Exposures, Groups, Metrics, and Semantic-Layer Awareness: Downstream Consumers, Ownership, Maturity, Semantic Models, Metric Definitions, and Scope Boundaries: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter21/Lesson3.html

Planned04

Exposures, Groups, Metrics, and Semantic-Layer Awareness: Downstream Consumers, Ownership, Maturity, Semantic Models, Metric Definitions, and Scope Boundaries: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter21/Lesson4.html

Planned05

Checkpoint Lab — Exposures, Groups, Metrics, and Semantic-Layer Awareness: Downstream Consumers, Ownership, Maturity, Semantic Models, Metric Definitions, and Scope Boundaries: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter21/Lesson5.html

Planned

22

Chapter 22

Selectors and Graph Operators: --select/--exclude, Tags, Paths, Config Selectors, Parents/Children, Intersections/Unions, Indirect Selection, and YAML Selectors

5 lessons

01

Selectors and Graph Operators: --select/--exclude, Tags, Paths, Config Selectors, Parents/Children, Intersections/Unions, Indirect Selection, and YAML Selectors: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter22/Lesson1.html

Planned02

Selectors and Graph Operators: --select/--exclude, Tags, Paths, Config Selectors, Parents/Children, Intersections/Unions, Indirect Selection, and YAML Selectors: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter22/Lesson2.html

Planned03

Selectors and Graph Operators: --select/--exclude, Tags, Paths, Config Selectors, Parents/Children, Intersections/Unions, Indirect Selection, and YAML Selectors: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter22/Lesson3.html

Planned04

Selectors and Graph Operators: --select/--exclude, Tags, Paths, Config Selectors, Parents/Children, Intersections/Unions, Indirect Selection, and YAML Selectors: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter22/Lesson4.html

Planned05

Checkpoint Lab — Selectors and Graph Operators: --select/--exclude, Tags, Paths, Config Selectors, Parents/Children, Intersections/Unions, Indirect Selection, and YAML Selectors: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter22/Lesson5.html

Planned

23

Chapter 23

State, Defer, and Slim CI: manifest Comparison, state:modified, --defer, Favor-State, Logical State, Artifacts, and Safe PR Validation

5 lessons

01

State, Defer, and Slim CI: manifest Comparison, state:modified, --defer, Favor-State, Logical State, Artifacts, and Safe PR Validation: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter23/Lesson1.html

Planned02

State, Defer, and Slim CI: manifest Comparison, state:modified, --defer, Favor-State, Logical State, Artifacts, and Safe PR Validation: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter23/Lesson2.html

Planned03

State, Defer, and Slim CI: manifest Comparison, state:modified, --defer, Favor-State, Logical State, Artifacts, and Safe PR Validation: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter23/Lesson3.html

Planned04

State, Defer, and Slim CI: manifest Comparison, state:modified, --defer, Favor-State, Logical State, Artifacts, and Safe PR Validation: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter23/Lesson4.html

Planned05

Checkpoint Lab — State, Defer, and Slim CI: manifest Comparison, state:modified, --defer, Favor-State, Logical State, Artifacts, and Safe PR Validation: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter23/Lesson5.html

Planned

24

Chapter 24

Artifacts and Programmatic Interfaces: manifest.json, run_results.json, catalog.json, sources.json, Semantic Manifest Awareness, and Automation Consumers

5 lessons

01

Artifacts and Programmatic Interfaces: manifest.json, run_results.json, catalog.json, sources.json, Semantic Manifest Awareness, and Automation Consumers: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter24/Lesson1.html

Planned02

Artifacts and Programmatic Interfaces: manifest.json, run_results.json, catalog.json, sources.json, Semantic Manifest Awareness, and Automation Consumers: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter24/Lesson2.html

Planned03

Artifacts and Programmatic Interfaces: manifest.json, run_results.json, catalog.json, sources.json, Semantic Manifest Awareness, and Automation Consumers: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter24/Lesson3.html

Planned04

Artifacts and Programmatic Interfaces: manifest.json, run_results.json, catalog.json, sources.json, Semantic Manifest Awareness, and Automation Consumers: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter24/Lesson4.html

Planned05

Checkpoint Lab — Artifacts and Programmatic Interfaces: manifest.json, run_results.json, catalog.json, sources.json, Semantic Manifest Awareness, and Automation Consumers: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter24/Lesson5.html

Planned

25

Chapter 25

Hooks and Operations: pre/post-hooks, on-run-start/end, run-operation, Transactions, Grants, Maintenance SQL, and When Hooks Become Technical Debt

5 lessons

01

Hooks and Operations: pre/post-hooks, on-run-start/end, run-operation, Transactions, Grants, Maintenance SQL, and When Hooks Become Technical Debt: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter25/Lesson1.html

Planned02

Hooks and Operations: pre/post-hooks, on-run-start/end, run-operation, Transactions, Grants, Maintenance SQL, and When Hooks Become Technical Debt: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter25/Lesson2.html

Planned03

Hooks and Operations: pre/post-hooks, on-run-start/end, run-operation, Transactions, Grants, Maintenance SQL, and When Hooks Become Technical Debt: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter25/Lesson3.html

Planned04

Hooks and Operations: pre/post-hooks, on-run-start/end, run-operation, Transactions, Grants, Maintenance SQL, and When Hooks Become Technical Debt: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter25/Lesson4.html

Planned05

Checkpoint Lab — Hooks and Operations: pre/post-hooks, on-run-start/end, run-operation, Transactions, Grants, Maintenance SQL, and When Hooks Become Technical Debt: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter25/Lesson5.html

Planned

26

Chapter 26

Environment Design: Dev/CI/Staging/Prod Targets, Schema Generation, Per-Developer Isolation, Cloning/Deferral, Secrets, and Promotion Strategy

5 lessons

01

Environment Design: Dev/CI/Staging/Prod Targets, Schema Generation, Per-Developer Isolation, Cloning/Deferral, Secrets, and Promotion Strategy: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter26/Lesson1.html

Planned02

Environment Design: Dev/CI/Staging/Prod Targets, Schema Generation, Per-Developer Isolation, Cloning/Deferral, Secrets, and Promotion Strategy: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter26/Lesson2.html

Planned03

Environment Design: Dev/CI/Staging/Prod Targets, Schema Generation, Per-Developer Isolation, Cloning/Deferral, Secrets, and Promotion Strategy: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter26/Lesson3.html

Planned04

Environment Design: Dev/CI/Staging/Prod Targets, Schema Generation, Per-Developer Isolation, Cloning/Deferral, Secrets, and Promotion Strategy: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter26/Lesson4.html

Planned05

Checkpoint Lab — Environment Design: Dev/CI/Staging/Prod Targets, Schema Generation, Per-Developer Isolation, Cloning/Deferral, Secrets, and Promotion Strategy: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter26/Lesson5.html

Planned

27

Chapter 27

Orchestration: dbt build/run/test/snapshot/source freshness, Exit Codes, Airflow/Dagster/CI Integration, Retries, Idempotency, and Job Boundaries

5 lessons

01

Orchestration: dbt build/run/test/snapshot/source freshness, Exit Codes, Airflow/Dagster/CI Integration, Retries, Idempotency, and Job Boundaries: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter27/Lesson1.html

Planned02

Orchestration: dbt build/run/test/snapshot/source freshness, Exit Codes, Airflow/Dagster/CI Integration, Retries, Idempotency, and Job Boundaries: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter27/Lesson2.html

Planned03

Orchestration: dbt build/run/test/snapshot/source freshness, Exit Codes, Airflow/Dagster/CI Integration, Retries, Idempotency, and Job Boundaries: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter27/Lesson3.html

Planned04

Orchestration: dbt build/run/test/snapshot/source freshness, Exit Codes, Airflow/Dagster/CI Integration, Retries, Idempotency, and Job Boundaries: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter27/Lesson4.html

Planned05

Checkpoint Lab — Orchestration: dbt build/run/test/snapshot/source freshness, Exit Codes, Airflow/Dagster/CI Integration, Retries, Idempotency, and Job Boundaries: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter27/Lesson5.html

Planned

28

Chapter 28

Warehouse Performance: Query Plans, Partitioning/Clustering, Materialization Choice, Incremental Predicates, Statistics, Warehouse Sizing, and Cost Controls

5 lessons

01

Warehouse Performance: Query Plans, Partitioning/Clustering, Materialization Choice, Incremental Predicates, Statistics, Warehouse Sizing, and Cost Controls: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter28/Lesson1.html

Planned02

Warehouse Performance: Query Plans, Partitioning/Clustering, Materialization Choice, Incremental Predicates, Statistics, Warehouse Sizing, and Cost Controls: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter28/Lesson2.html

Planned03

Warehouse Performance: Query Plans, Partitioning/Clustering, Materialization Choice, Incremental Predicates, Statistics, Warehouse Sizing, and Cost Controls: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter28/Lesson3.html

Planned04

Warehouse Performance: Query Plans, Partitioning/Clustering, Materialization Choice, Incremental Predicates, Statistics, Warehouse Sizing, and Cost Controls: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter28/Lesson4.html

Planned05

Checkpoint Lab — Warehouse Performance: Query Plans, Partitioning/Clustering, Materialization Choice, Incremental Predicates, Statistics, Warehouse Sizing, and Cost Controls: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter28/Lesson5.html

Planned

29

Chapter 29

Debugging and Troubleshooting: dbt debug/compile, Compiled SQL, Logs, Adapter Errors, Database Errors, Partial Parsing, Cache Issues, and Reproduction

5 lessons

01

Debugging and Troubleshooting: dbt debug/compile, Compiled SQL, Logs, Adapter Errors, Database Errors, Partial Parsing, Cache Issues, and Reproduction: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter29/Lesson1.html

Planned02

Debugging and Troubleshooting: dbt debug/compile, Compiled SQL, Logs, Adapter Errors, Database Errors, Partial Parsing, Cache Issues, and Reproduction: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter29/Lesson2.html

Planned03

Debugging and Troubleshooting: dbt debug/compile, Compiled SQL, Logs, Adapter Errors, Database Errors, Partial Parsing, Cache Issues, and Reproduction: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter29/Lesson3.html

Planned04

Debugging and Troubleshooting: dbt debug/compile, Compiled SQL, Logs, Adapter Errors, Database Errors, Partial Parsing, Cache Issues, and Reproduction: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter29/Lesson4.html

Planned05

Checkpoint Lab — Debugging and Troubleshooting: dbt debug/compile, Compiled SQL, Logs, Adapter Errors, Database Errors, Partial Parsing, Cache Issues, and Reproduction: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter29/Lesson5.html

Planned

30

Chapter 30

Advanced SQL Engineering: Reusable CTE Patterns, Windows, Dimensional Models, Data Vault Awareness, Deduplication, Surrogate Keys, and Grain Enforcement

5 lessons

01

Advanced SQL Engineering: Reusable CTE Patterns, Windows, Dimensional Models, Data Vault Awareness, Deduplication, Surrogate Keys, and Grain Enforcement: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter30/Lesson1.html

Planned02

Advanced SQL Engineering: Reusable CTE Patterns, Windows, Dimensional Models, Data Vault Awareness, Deduplication, Surrogate Keys, and Grain Enforcement: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter30/Lesson2.html

Planned03

Advanced SQL Engineering: Reusable CTE Patterns, Windows, Dimensional Models, Data Vault Awareness, Deduplication, Surrogate Keys, and Grain Enforcement: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter30/Lesson3.html

Planned04

Advanced SQL Engineering: Reusable CTE Patterns, Windows, Dimensional Models, Data Vault Awareness, Deduplication, Surrogate Keys, and Grain Enforcement: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter30/Lesson4.html

Planned05

Checkpoint Lab — Advanced SQL Engineering: Reusable CTE Patterns, Windows, Dimensional Models, Data Vault Awareness, Deduplication, Surrogate Keys, and Grain Enforcement: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter30/Lesson5.html

Planned

31

Chapter 31

Data Quality Engineering: Test Layering, Freshness SLOs, Reconciliation, Anomaly Detection Boundaries, Contract Tests, Observability Tools, and Incident Response

5 lessons

01

Data Quality Engineering: Test Layering, Freshness SLOs, Reconciliation, Anomaly Detection Boundaries, Contract Tests, Observability Tools, and Incident Response: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter31/Lesson1.html

Planned02

Data Quality Engineering: Test Layering, Freshness SLOs, Reconciliation, Anomaly Detection Boundaries, Contract Tests, Observability Tools, and Incident Response: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter31/Lesson2.html

Planned03

Data Quality Engineering: Test Layering, Freshness SLOs, Reconciliation, Anomaly Detection Boundaries, Contract Tests, Observability Tools, and Incident Response: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter31/Lesson3.html

Planned04

Data Quality Engineering: Test Layering, Freshness SLOs, Reconciliation, Anomaly Detection Boundaries, Contract Tests, Observability Tools, and Incident Response: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter31/Lesson4.html

Planned05

Checkpoint Lab — Data Quality Engineering: Test Layering, Freshness SLOs, Reconciliation, Anomaly Detection Boundaries, Contract Tests, Observability Tools, and Incident Response: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter31/Lesson5.html

Planned

32

Chapter 32

Security and Governance: Warehouse Roles, Least Privilege, PII Handling, Grants, Masking Policies, Secrets, Auditability, and Separation of Duties

5 lessons

01

Security and Governance: Warehouse Roles, Least Privilege, PII Handling, Grants, Masking Policies, Secrets, Auditability, and Separation of Duties: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter32/Lesson1.html

Planned02

Security and Governance: Warehouse Roles, Least Privilege, PII Handling, Grants, Masking Policies, Secrets, Auditability, and Separation of Duties: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter32/Lesson2.html

Planned03

Security and Governance: Warehouse Roles, Least Privilege, PII Handling, Grants, Masking Policies, Secrets, Auditability, and Separation of Duties: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter32/Lesson3.html

Planned04

Security and Governance: Warehouse Roles, Least Privilege, PII Handling, Grants, Masking Policies, Secrets, Auditability, and Separation of Duties: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter32/Lesson4.html

Planned05

Checkpoint Lab — Security and Governance: Warehouse Roles, Least Privilege, PII Handling, Grants, Masking Policies, Secrets, Auditability, and Separation of Duties: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter32/Lesson5.html

Planned

33

Chapter 33

CI/CD and Release Engineering: Pull-Request Builds, Slim CI, Unit/Data Tests, Documentation Checks, Package Locks, Environment Promotion, and Rollback

5 lessons

01

CI/CD and Release Engineering: Pull-Request Builds, Slim CI, Unit/Data Tests, Documentation Checks, Package Locks, Environment Promotion, and Rollback: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter33/Lesson1.html

Planned02

CI/CD and Release Engineering: Pull-Request Builds, Slim CI, Unit/Data Tests, Documentation Checks, Package Locks, Environment Promotion, and Rollback: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter33/Lesson2.html

Planned03

CI/CD and Release Engineering: Pull-Request Builds, Slim CI, Unit/Data Tests, Documentation Checks, Package Locks, Environment Promotion, and Rollback: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter33/Lesson3.html

Planned04

CI/CD and Release Engineering: Pull-Request Builds, Slim CI, Unit/Data Tests, Documentation Checks, Package Locks, Environment Promotion, and Rollback: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter33/Lesson4.html

Planned05

Checkpoint Lab — CI/CD and Release Engineering: Pull-Request Builds, Slim CI, Unit/Data Tests, Documentation Checks, Package Locks, Environment Promotion, and Rollback: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter33/Lesson5.html

Planned

34

Chapter 34

Upgrading dbt Core 1.x: Adapter Compatibility, Deprecations, Behavior-Change Flags, Parser/Manifest Changes, Package Compatibility, and Regression Gates

5 lessons

01

Upgrading dbt Core 1.x: Adapter Compatibility, Deprecations, Behavior-Change Flags, Parser/Manifest Changes, Package Compatibility, and Regression Gates: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter34/Lesson1.html

Planned02

Upgrading dbt Core 1.x: Adapter Compatibility, Deprecations, Behavior-Change Flags, Parser/Manifest Changes, Package Compatibility, and Regression Gates: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter34/Lesson2.html

Planned03

Upgrading dbt Core 1.x: Adapter Compatibility, Deprecations, Behavior-Change Flags, Parser/Manifest Changes, Package Compatibility, and Regression Gates: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter34/Lesson3.html

Planned04

Upgrading dbt Core 1.x: Adapter Compatibility, Deprecations, Behavior-Change Flags, Parser/Manifest Changes, Package Compatibility, and Regression Gates: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter34/Lesson4.html

Planned05

Checkpoint Lab — Upgrading dbt Core 1.x: Adapter Compatibility, Deprecations, Behavior-Change Flags, Parser/Manifest Changes, Package Compatibility, and Regression Gates: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter34/Lesson5.html

Planned

35

Chapter 35

dbt Core 2.0/Fusion Migration Outlook: Rust Engine, Stricter Semantics, New Capabilities, Alpha-vs-Stable Discipline, Compatibility Testing, and Adoption Planning

5 lessons

01

dbt Core 2.0/Fusion Migration Outlook: Rust Engine, Stricter Semantics, New Capabilities, Alpha-vs-Stable Discipline, Compatibility Testing, and Adoption Planning: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter35/Lesson1.html

Planned02

dbt Core 2.0/Fusion Migration Outlook: Rust Engine, Stricter Semantics, New Capabilities, Alpha-vs-Stable Discipline, Compatibility Testing, and Adoption Planning: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter35/Lesson2.html

Planned03

dbt Core 2.0/Fusion Migration Outlook: Rust Engine, Stricter Semantics, New Capabilities, Alpha-vs-Stable Discipline, Compatibility Testing, and Adoption Planning: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter35/Lesson3.html

Planned04

dbt Core 2.0/Fusion Migration Outlook: Rust Engine, Stricter Semantics, New Capabilities, Alpha-vs-Stable Discipline, Compatibility Testing, and Adoption Planning: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter35/Lesson4.html

Planned05

Checkpoint Lab — dbt Core 2.0/Fusion Migration Outlook: Rust Engine, Stricter Semantics, New Capabilities, Alpha-vs-Stable Discipline, Compatibility Testing, and Adoption Planning: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter35/Lesson5.html

Planned

36

Chapter 36

Production Capstone: Model, Test, Snapshot, Increment, Document, Govern, CI, Deploy, Observe, Rebuild, and Upgrade a Production dbt Project

5 lessons

01

Production Capstone: Model, Test, Snapshot, Increment, Document, Govern, CI, Deploy, Observe, Rebuild, and Upgrade a Production dbt Project: Concepts, Terminology, Architecture, and Mental ModelPlanned lesson · reserved path Chapter36/Lesson1.html

Planned02

Production Capstone: Model, Test, Snapshot, Increment, Document, Govern, CI, Deploy, Observe, Rebuild, and Upgrade a Production dbt Project: Guided Hands-On Workflow, Commands, APIs, and ConfigurationPlanned lesson · reserved path Chapter36/Lesson2.html

Planned03

Production Capstone: Model, Test, Snapshot, Increment, Document, Govern, CI, Deploy, Observe, Rebuild, and Upgrade a Production dbt Project: Design Choices, Scaling Behavior, Compatibility, and TradeoffsPlanned lesson · reserved path Chapter36/Lesson3.html

Planned04

Production Capstone: Model, Test, Snapshot, Increment, Document, Govern, CI, Deploy, Observe, Rebuild, and Upgrade a Production dbt Project: Failure Modes, Diagnostics, Security, Reliability, and PerformancePlanned lesson · reserved path Chapter36/Lesson4.html

Planned05

Checkpoint Lab — Production Capstone: Model, Test, Snapshot, Increment, Document, Govern, CI, Deploy, Observe, Rebuild, and Upgrade a Production dbt Project: Build, Test, Measure, Troubleshoot, and Explain the ResultPlanned lesson · reserved path Chapter36/Lesson5.html

Planned