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.