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 Setup for Azure PostgreSQL
Content coming soon...
Suggested Topics
- Installing dbt-core and the dbt-postgres adapter
- Configuring profiles.yml for Azure PostgreSQL connection
- Authentication options: password-based login vs Entra ID (passwordless)
- Creating a dbt project with dbt init
- Defining sources in a schema.yml file pointing to your raw tables
- Running dbt debug to verify connectivity
- Your first dbt run: a simple staging model that selects from a source
- Project organization: separating staging models from mart models with folders
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.