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.
Can you use the comparison models for testing with different technologies IE SQL Server and Snowflake
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