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)

Building Your First Mart

Content coming soon...

Suggested Topics

• What a mart is: a business-ready, query-optimized model for end users
• Designing a mart from Week 9 modeling concepts: choosing grain, keys, and measures
• Building a mart model that references staging models using ref()
• Adding tests and documentation to your mart
• Materializing as a table vs a view: trade-offs for dashboard performance
• Connecting the mart to the data that your ingestion pipeline loads
• Verifying your mart with analytical queries before handing it to a dashboard
• The mart as a contract: how downstream consumers depend on stable column names and types

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.