Introduction to dbt Core

dbt Setup for Azure PostgreSQL

SQL and Jinja Templating

dbt Tests

Incremental Models, Docs, and Snapshots

Building Your First Mart

Practice

Assignment

Gotchas & Pitfalls

Week 10 Lesson Plan (Teachers)

dbt Tests

Content coming soon...

Suggested Topics

• Why testing matters: catching data issues before they reach dashboards
• Built-in generic tests: notnull, unique, acceptedvalues, relationships
• Adding tests in schema.yml files alongside model documentation
• Running tests with dbt test and interpreting failures
• Singular tests: custom SQL queries that assert business rules
• Test severity levels: warn vs error and when to use each
• Testing strategy: which columns to test and how many tests are enough
• Combining dbt tests with the validation queries from Week 9
• Integrating dbt test into your pipeline workflow

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0

*https://hackyourfuture.net/*

Found a mistake or have a suggestion? Let us know in the feedback form.