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)

Content

Practice

Content coming soon...

Suggested Activities

• Set up a dbt project connected to Azure PostgreSQL and run dbt debug successfully
• Create a staging model that cleans and renames columns from a raw source table
• Write a mart model that joins staging models and adds business logic
• Add not_null and unique tests to your staging and mart models and run dbt test
• Use Jinja to write a macro that generates a repeated SQL pattern
• Generate dbt docs and explore the lineage graph of your project

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.