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)

Assignment

Content coming soon...

Suggested Project Scope

• Set up a dbt project with sources pointing to your ingested raw tables in Azure PostgreSQL
• Build at least one staging model that cleans and renames raw data
• Build one mart model that will be used as the data source for next week's dashboard
• Add not_null and unique tests to key columns in both staging and mart models
• Document all models and columns in schema.yml with descriptions
• Generate dbt docs and include a screenshot of the lineage graph
• Deliverables: dbt project repo, passing dbt run and dbt test output, generated docs, brief write-up explaining your model design decisions

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.