Advanced CI -- dbt compare

Enterprise Cloud Feature

What is it?

dbt Cloud compares the changes between the last applied state of the production environment (defaulting to deferral for lower compute costs) and the latest changes from the pull request

Simple Explainer

My CI jobs tell me that it will build, dbt compare what me what it will build. Does it drop columns? Change data types? 10x the number of records in the table? These can cause major problems and are easily spotted by Advanced CI

What Functional Requirement Does it Satisfy?

Data quality & trust signals

How it Reduces Cost

NA

How it Helps Data Teams Ship Faster

NA

How it Helps Orgs Build Trust in Data and Teams

It allows you to spot major changes to the shape of your tables that might not have been intentional and allows you to preview the change side-by-side with the production results before pushing it to production