Learndbt Analytics Engineer
Upskillz Learning

dbt Analytics Engineer

Build, test, govern, debug, and operate a dbt project by reasoning from its graph, compiled SQL, persisted state, and external inputs.

8 modules · 38 available sessions · 12h 0m

Restoring progress—

Your place is saved on this device.

Start with · Module 1Orders pipeline investigation12 min
Restoring your place…

Modules and sessions

8 modules
Module 1 · AvailableDeveloping dbt Models10 sessions

Build, configure, and connect models across a dbt project.

  1. Orders pipeline investigation12 min
    Start Orders pipeline investigation
  2. Materializations18 min
    Start Materializations
  3. Incremental Models18 min
    Start Incremental Models
  4. Snapshots40 min
    Start Snapshots
  5. Project Resources18 min
    Start Project Resources
  6. Model Configuration18 min
    Start Model Configuration
  7. Model Access, Groups, and Contracts20 min
    Start Model Access, Groups, and Contracts
  8. Jinja Context and this18 min
    Start Jinja Context and this
  9. Build and Selection Behavior18 min
    Start Build and Selection Behavior
  10. Python Models18 min
    Start Python Models
Module 2 · AvailableImplementing dbt Tests3 sessions

Validate model assumptions with generic, singular, and unit tests.

  1. Generic Data Tests18 min
    Start Generic Data Tests
  2. Singular Data Tests18 min
    Start Singular Data Tests
  3. Unit Tests18 min
    Start Unit Tests
Module 3 · AvailableDebugging Data Modeling Errors6 sessions

Trace parsing, compilation, runtime, and dependency failures.

  1. Parsing and Compilation18 min
    Start Parsing and Compilation
  2. Runtime Errors18 min
    Start Runtime Errors
  3. Dependency Debugging20 min
    Start Dependency Debugging
  4. Jinja and Macro Debugging20 min
    Start Jinja and Macro Debugging
  5. dbt Debug and Retry20 min
    Start dbt Debug and Retry
  6. Incremental Troubleshooting18 min
    Start Incremental Troubleshooting
Module 4 · AvailableModel Governance4 sessions

Make model interfaces clear, documented, and controlled.

  1. Model Contracts18 min
    Start Model Contracts
  2. Model Access and Groups18 min
    Start Model Access and Groups
  3. Model Documentation18 min
    Start Model Documentation
  4. Project Configuration18 min
    Start Project Configuration
Module 5 · AvailableManaging Data Pipelines6 sessions

Run, select, and recover model pipelines predictably.

  1. dbt Build and Command Execution18 min
    Start dbt Build and Command Execution
  2. Node Selection18 min
    Start Node Selection
  3. Full Refresh and Seed Reloads20 min
    Start Full Refresh and Seed Reloads
  4. Hooks18 min
    Start Hooks
  5. Tags20 min
    Start Tags
  6. Failure Handling20 min
    Start Failure Handling
Module 6 · AvailableLeveraging dbt State4 sessions

Use prior artifacts to make state-aware decisions.

  1. State Selection18 min
    Start State Selection
  2. State Artifacts18 min
    Start State Artifacts
  3. Deferral18 min
    Start Deferral
  4. Result and Source Status Selectors20 min
    Start Result and Source Status Selectors
Module 7 · AvailableDocumentation3 sessions

Publish useful context about models and their consumers.

  1. Documentation Generation and Commands18 min
    Start Documentation Generation and Commands
  2. Docs Blocks and doc()18 min
    Start Docs Blocks and doc()
  3. Exposures18 min
    Start Exposures
Module 8 · AvailableExternal Dependencies2 sessions

Represent data that enters the project from outside dbt.

  1. Sources and Freshness20 min
    Start Sources and Freshness
  2. Source Tests20 min
    Start Source Tests

Your progress is saved on this device.