MOC: dbt

The SQL transformation layer — from project setup through model design to production operations. 22 pages covering dbt fundamentals, the staging → intermediate → mart progression, testing, macros, and adapter-specific patterns for BigQuery and SQL Server. Expand any section to browse contents.

mindmap
  ((Foundations))
    (core concepts)
    (project structure)
    (CLI reference)

Foundations

domain-foundations

dbt core concepts, project structure conventions, CLI commands, and a quick-reference cheat sheet for day-to-day development.

mindmap
  ((Model Design))
    (staging models)
    (intermediate models)
    (mart models)
    (materializations)

Model Design

domain-model-design

The staging-to-intermediate-to-mart progression, materialisation strategies, and the patterns that shape how dbt models transform raw data into analytics-ready tables.

mindmap
  ((Extensions and Quality))
    (macros, Jinja)
    (packages)
    (snapshots, SCD)
    (testing framework)
    (data contracts)

Extensions and Quality

domain-extensions-and-quality

Macros, Jinja templating, community packages, snapshot-based SCD tracking, the testing framework, and data contracts for enforcing schema guarantees.

mindmap
  ((Operations and Adapters))
    (Airflow integration)
    (CI/CD)
    (documentation, lineage)
    (observability)
    (performance tuning)
    (troubleshooting)
    (BigQuery adapter)
    (SQL Server adapter)
    (cross-adapter patterns)

Operations and Adapters

domain-operations-and-adapters

Running dbt in production — Airflow integration, CI/CD pipelines, documentation and lineage, observability, performance tuning, troubleshooting, and adapter-specific patterns for BigQuery, SQL Server, and cross-adapter compatibility.

dbt Cross-References

• Data Architecture — dbt transformation layer theory and medallion architecture
• SQL Server — SQL Server pipeline patterns that dbt automates
• DB Queries — BigQuery and SQL Server query patterns used in dbt models
• GitHub Actions — CI/CD pipelines running dbt test and build
• Observability — dbt observability in the broader monitoring stack