dbt / Intermediate: history and controlled workflows

dbt β€” Intermediate: history and controlled workflows

Build stable interfaces and explicit state transitions with governed fixtures, reference data and selection.

6 lessons Β· No account required

What you will learn

  • Evaluate contracts, incremental correctness, snapshots and source completeness.
  • Choose selectors and unit fixtures with precise scope and execution limits.

  1. Contracts, documentation and model interfaces

    Publish a stable branch model while separating column-shape contracts, business assertions and access governance.

    Start learning

  2. Incremental correctness and late changes

    Design candidate selection, stable keys and replay behavior before optimizing the amount of transformed data.

    Start learning

  3. Snapshots and observed history

    Track changing branch attributes while distinguishing source-change time, snapshot observation and complete business history.

    Start learning

  4. Seeds, reference data and source freshness

    Govern small static lookup data and interpret freshness signals without treating either as a complete ingestion system.

    Start learning

  5. Selectors and controlled execution scope

    Express graph scope precisely and preview selected resources before authorizing expensive or destructive work.

    Start learning

  6. Unit tests and fixture boundaries

    Isolate loan-state logic with small inputs while keeping warehouse integration, data tests and incremental merge verification distinct.

    Start learning
Back to course