Week 10 - SQL Transformations with dbt

Introduction to dbt Core

dbt Setup for Azure PostgreSQL

SQL and Jinja Templating

dbt Tests

Incremental Models, Docs, and Snapshots

Building Your First Mart

Week 10 Gotchas & Pitfalls

Practice

Week 10 Assignment: Build a Daily Borough Stats Mart with dbt

Week 10 - Video Guide

Week 10 Lesson Plan (Teachers)

Week 10 - Video Guide

<aside> ⚠️ Note: These videos use dbt Cloud with BigQuery. This week's curriculum uses dbt Core with Azure PostgreSQL. The concepts are transferable but the specific setup steps will differ.

</aside>

Analytics Engineering with dbt

dbt Cloud Setup

dbt Cloud & BigQuery Setup* (1 min)

Watch GIF

Key concepts: BigQuery roles, dbt Cloud connection, project initialization.

Jointly created by HackYourFuture and the Google DeepMind team.

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0 *https://hackyourfuture.net/*

Built with ❤️ by the HackYourFuture community · Thank you, contributors

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