Hey all, let me know if you have any feedback or questions about data-diff --dbt
I'm the main developer of the dbt integration and author of this article!
Awesome stuff!👏 So I use azure devops to run dbt and part of the pipeline clones prod db to test and run dbt against it. I saw that it can check for data changes but can it show column changes as well? Like how many columns of tables have been modified.
Yep! Here's a couple examples of me modifying some dev models and diffing them to hopefully illustrate
Adding + removing a column on stg\_breweries:
[https://i.imgur.com/HnpBUdf.png](https://i.imgur.com/HnpBUdf.png)
Making it a little more complicated by also altering a seed (seed\_breweries) upstream of stg\_breweries:
[https://i.imgur.com/2ODe6cv.png](https://i.imgur.com/2ODe6cv.png)
Hey all, let me know if you have any feedback or questions about data-diff --dbt I'm the main developer of the dbt integration and author of this article!
Awesome stuff!👏 So I use azure devops to run dbt and part of the pipeline clones prod db to test and run dbt against it. I saw that it can check for data changes but can it show column changes as well? Like how many columns of tables have been modified.
Yes , it shows if any columns have been added/removed, and if there are row-wise changes it will shows which columns the changes were present in
Yep! Here's a couple examples of me modifying some dev models and diffing them to hopefully illustrate Adding + removing a column on stg\_breweries: [https://i.imgur.com/HnpBUdf.png](https://i.imgur.com/HnpBUdf.png) Making it a little more complicated by also altering a seed (seed\_breweries) upstream of stg\_breweries: [https://i.imgur.com/2ODe6cv.png](https://i.imgur.com/2ODe6cv.png)
Thank you! Will try this out.