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: