Can you use the comparison models for testing with different technologies IE SQL Server and Snowflake

We are rebuilding a data warehouse from sql server to snowflake and would like a good way to test that are tables match the tables in the legacy DB. From structure and data.

dbt itself can only query one warehouse at a time, but you can use the audit helper package to ensure that the transformations give consistent results by generating summary queries:

You could try data-diff

1 Like