Advanced Testing

Learn more about the theory of data testing and the practice of creating custom generic tests, leveraging tests in packages, and applying test configurations. (approximately 4 hours).

Introduction to Advanced Testing (60 mins)

Learning Objectives Intro Testing Techniques What to Test and Why Test Coverage Practice Review Additional Information How to engage with this course

Test Deployment (60 mins)

Learning Objectives When to Test Testing Commands Storing Test Failures in the Database Practice Review

Custom Tests (40 mins)

Learning Objectives Writing Custom Tests Singular Tests Creating Singular Tests Custom Generic Tests Promoting a Singular Test to a Generic Test Overwriting Native Tests Practice Exemplar Review

Tests in Packages (45 mins)

Learning Objectives Tests from Packages What is dbt Utils Implementing dbt Utils What is dbt Expectations Implementing dbt Expectations What is audit helper Implementing audit helper Practice Exemplar Review

Test Configurations (50 mins)

Learning Objectives What are Test Configurations Severity config for tests Where config for tests Limit config for tests Store failures config for test Project level test configuration Practice Exemplar Review Quick Survey