Tutorial: Using dbt to Test for Schema Changes

5 different types of changes and the specific tests to detect them

Schema changes can really ruin everything, can’t they? Imagine you spent months building out dimensional and fact models in your production database, only to have a bunch of columns renamed, or their data type changed.

Now, the downstream data models are all broken. The model that pieced together all of your marketing spending is broken because the dolla…