Welcome to dbt@scale¶
Give us feedback from day 1: PollEv.com/lucys123
A two-day hands-on workshop where you tackle a real-world dbt project under the hood of MediaPulse.
Link to the dbt Project(s): https://ca598.us1.dbt.com
Who's in the room¶
| Role | Organisation |
|---|---|
| Participants & host | DPG |
| Facilitation & analytics engineering | Xebia |
| dbt expertise & talks (day 2) | dbt Labs |
What you'll do¶
You'll work in one of three groups, each with a dedicated slice of the MediaPulse dbt projects to explore, fix, and extend. Every group shares the same codebase but focuses on different dbt concepts and different parts of the data platform.
| Group | Level | Theme |
|---|---|---|
| Group 1 | Next level dbt | modeling · testing · jinja/macros |
| Group 2 | Best practices and Multi-project dbt | testing · jinja/macros · dbt mesh |
| Group 3 | Power Users | testing · dbt mesh · model governance |
How to use this guide¶
- Use the top navigation tabs to jump between sections.
- Each group has an Overview (context + learning objectives) and a Modules including exercises to complete.
- Checklist steps include collapsible hints - try the task first, then expand the hint if you're stuck.
- The MediaPulse Project page documents the shared codebase: schemas, known bugs, and the overall structure.
Group assignments¶
Your group will correspond to the invite you received for this event. If you are unsure of your group you can see the groups listed here: What group am I in?
Discover what you're group is doing!
Use the top navigation tabs to jump directly to your group's Overview and Checklist pages.
Ground rules¶
- Collaborate freely within your group; share discoveries across groups.
- The bugs are intentional and your job is to find and fix them in the exercises.
- There is no single right answer for design decisions, you just need to be ready to defend your choices.
- Work together - design choices take decisions, decisions mean discussions.
- Ask facilitators for a nudge if you are stuck.