WORKSHOP: Testing in dbt – Break It ‘Til You Make It

Overview
Testing is a core part of any robust data pipeline—and dbt makes it easy to catch issues before they hit production. This 2-hour workshop will walk participants through the built-in testing capabilities of dbt and go one step further by building and running custom generic tests. Participants will explore how to ensure data quality, enforce model assumptions, and debug broken tests effectively.

Learning Objectives
By the end of this workshop, participants will be able to:
• Understand how and when to use built-in dbt tests (unique, not_null, relationships, etc.)
• Interpret test results and resolve failures
• Write their own custom generic tests using Jinja and YAML
• Apply tests to ensure data model integrity and catch issues early in the pipeline

Workshop Format
The workshop blends concise lectures with hands-on demos and guided exercises. Participants will explore real-world use cases, implement tests in live dbt projects, and collaborate on debugging broken models. There will be discussions and opportunities to share testing strategies.

Who Should Attend
This workshop is ideal for analytics engineers, data analysts, and data engineers who are already using dbt or those who are familiar with the core concepts of dbt and want to level up their testing practices.

Requirements
A GitHub account is required to connect to the Codespaces environment. Familiarity with SQL is required to make the most out of the workshop, and fundamental knowledge of dbt is recommended. There will be no local setup required.

ATTENTION! Seats are limited!