dbt Tests BigQuery Cost: Find Tests Scanning Full Tables
Your dbt tests may be the largest line in your BigQuery bill. Here is the SQL to find the worst offenders and the config to cut their scan cost.
Fintel Analytics blog
Expert perspectives on data analytics, AI agents, internal tools, and business intelligence from the Fintel Analytics team.
3 of 234 posts
Your dbt tests may be the largest line in your BigQuery bill. Here is the SQL to find the worst offenders and the config to cut their scan cost.
A dbt test set to warn reports a problem but never stops the build. Here is how to find every one in your project and decide which should fail.
Untested dbt models are silent liabilities. Learn how to find every model with no test coverage in BigQuery using runnable SQL and dbt commands — in under five minutes.