Slides (PDF)

The slide deck used in the Week 10 in-class session. The deck covers: welcome back + recap, the theme ("From SQL to dbt: Transformations as Code"), the assignment frame, a live build of the nyc_taxi project one chapter at a time (Ch1-Ch6) from the reference-repo branch chain (with a concept diagram for each key idea), one mixed live quiz, and an optional debugging drill.

<aside> 💡 Use this as a recap. If you missed class or want to re-walk the session, the deck mirrors the lesson: same order, chapter by chapter. Especially useful for the assignment frame and the per-chapter git switch + dbt build beats when you pick the project back up at home.

</aside>

Download

week_10__presentation.pdf

What's in it

Opening slides: Welcome back, the "From SQL to dbt" theme, today's plan, and the clone-the-reference-repo follow-along.
Assignment frame: the nyc_taxi_borough_daily mission and the chapter-to-task map, so each chapter connects to a deliverable.
Ch1 Introduction to dbt Core: what dbt is (the T in ELT), the ref() DAG, and a tour of the finished solution branch. Diagrams: the ELT pipeline (where dbt fits) and the ref() lineage DAG.
Ch2 Setup for Azure PostgreSQL: profiles.yml, dbt debug, personal dev_<your_name> schemas, starting from the ch2-dbt-setup-azure-postgres skeleton.
Ch3 SQL and Jinja Templating: Jinja compile timing, target/compiled/, building the first staging model on ch3-sql-jinja-templating. Diagram: the Jinja compile-time flow (.sql → compiled → Postgres).
☕ Break.
Ch4 Materializations & Layers: view vs table, who reads which model, on ch4-materializations. Diagram: view vs table side by side.
Ch5 dbt Tests: the dbt build circuit-breaker, severity: warn, singular tests, compound uniqueness, on ch5-dbt-testing. Diagram: the dbt build circuit-breaker as two timelines (bad data shipped vs blocked).
Ch6 Docs & Extras: dbt docs generate, the lineage graph, the three expected WARNs, on ch6-docs-and-extras then solution.
Live Quiz: one mixed 15-question round on Ch1-Ch6 + gotchas (or run the standalone self-paced version directly in your browser).
Optional live drill: debug a broken ref() on the exercise-debug-ref branch, plus the four async practice branches.
Q&A + wrap-up and the Week 11 (Airflow) preview.

The slides are deliberately student-facing only. The teacher's per-section script (pacing, timesink guardrails, quiz answer cribs, exercise reference solutions) lives in the GitHub-only week_10__lesson_plan.md (visible on GitHub only: not synced to Notion, so no link from this page).

Practice exercises (referenced in the drill slides)

The Week 10 practice drills are branches in the reference repo, each starting from the finished project (ch7-practice) so dbt actually runs. git switch to a branch, follow its EXERCISE.md, then git diff against the matching -solution branch.

Section	Practice exercise	What you practice
Optional live drill	`exercise-debug-ref`	Compile-error reading, DAG debugging
After class	`exercise-macros`	`safe_divide` macro, computed columns
After class	`exercise-singular-test`	Singular test authoring, the failing-test decision
After class	`exercise-column-propagation`	Staging-to-mart column propagation, `--select +`
After class	`exercise-generic-tests`	The four generic tests

Compare your work against the matching -solution branch for each.

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

CC BY-NC-SA 4.0 Icons

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

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