Workshop: Advanced Testing

Format: In-Person

Location: NOLA

Duration: 55 minutes

Audience: Analytics Engineer, Data Analyst, Data Engineer

Experience level: Intermediate

Bring your own laptop: Yes

Description:

Do you want to take your dbt project beyond simple unique and not-null tests, but don’t know where to start? Join the dbt Labs team for a deep dive into testing. You’ll learn how to customize tests to fit your unique needs, lean on the amazing dbt community for pre-built tests you can add straight to your project, and flex your Jinja skills by creating your own custom tests. By the end of this course you’ll be walking tall knowing that the data you’re providing to your customers is clean, reliable, and consistent.

You’ll learn how to:

• Customize test configurations (severity, filter tests, limit results)
• Apply tests from packages on the dbt package hub
• Build a singular test
• Promote that singular test to a generic test

Prerequisites:

• An existing dbt project to add more advanced testing
• Familiarity with SQL
• Basic familiarity with Jinja
• Experience with any data platform (Snowflake, Databricks, Redshift, BigQuery)