Creating a Data Model w/ dbt: Tests (Part 3/3)

Over the last two weeks, we've walked through how to create a foundational star schema data model using a tool like dbt.

We covered how to create Dimensions and Facts to make up the core model.

But creating the tables alone is just the first step.

Because as we know...data and custom logic is rarely ever 100% perfect.

Which is why having processes to test the quality of the data is incredibly important as well.

Fortunately, dbt provides some great built-in functionality to help address this scenario with just a few simple configurations.

And without needing to overcomplicate things early on.

So in the last video of this 3-part mini series, you'll see how to put a bow around the initial data model by adding some baseline data quality tests.