From the course: Data Engineering: dbt for SQL

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Challenge: Testing SQL

Challenge: Testing SQL

From the course: Data Engineering: dbt for SQL

Start my 1-month free trial Buy for my team

Challenge: Testing SQL

“

(upbeat electronic music) - [Instructor] Let's go back to the example of our advertising company from the first video in this chapter. For this challenge, we're going to help the company get their testing infrastructure in order. To get started, first open up chapter5/models/adid_data.sql in the VS Code UI. Then open Lineage View in the DBT Power User plugin. You can see this model reads from a parent, raw_adid_data. Next, let's shift our attention to the schema.yaml file. Upon inspection, you'll notice that the schema in its current form lacks any tests. Now our mission is to add some of the essential built-in DBT tests to ensure data quality and reliability for this kind of data. Modify the schema.yaml file to add some of the built-in DBT tests that you believe would be necessary to have in this kind of data. As you contemplate the tests to add, consider the descriptions of each of the columns provided. These will…

Contents