dbt / Basic: project and model foundations

dbt β€” Basic: project and model foundations

Define framework boundaries, logical inputs, model grain, template context and tested assertions.

6 lessons Β· No account required

What you will learn

  • Explain source/ref graphs, Jinja phases and materialization scope.
  • Write clear failing-row tests without overstating database enforcement.

  1. Framework, runtime and project boundaries

    Locate dbt inside a library analytics system and distinguish authoring, execution, adapters and hosted capabilities.

    Start learning

  2. Sources, staging and dependency graphs

    Declare library inputs and model relationships without hiding dependencies behind hardcoded relation names.

    Start learning

  3. Model grain, types and business SQL

    Define one-row meaning and explicit data interpretation before turning loan records into reusable analytics.

    Start learning

  4. Jinja, macros and execution context

    Generate reviewable SQL while keeping string arguments, dependency discovery and warehouse side effects explicit.

    Start learning

  5. Materializations and configuration precedence

    Choose how a model becomes a relation and review configuration scope before assuming persistence, freshness or cost.

    Start learning

  6. Data tests and failing records

    Turn loan invariants into explicit failing-row queries without confusing tests with continuously enforced database constraints.

    Start learning
Back to course