Fintel Analyticsdbt Full-Refresh Models in BigQuery: Stop the Silent Cost Bleed
dbt full-refresh models in BigQuery silently balloon your cloud bill as data grows. Here's how to find the offenders, understand the real cost, and migrate safely to incremental.
Fintel Analytics blog
Data & AI Insights
Expert perspectives on data analytics, AI agents, internal tools, and business intelligence from the Fintel Analytics team.
6 of 206 posts
dbt Incremental Subquery Filter in BigQuery: Full Scan Every Run
Your dbt incremental model has a WHERE clause, but BigQuery is still scanning the entire table on every run. Here's how to detect it and fix it for good.
dbt Incremental Models Strategy: When and How to Use Them
Full table rebuilds are silently draining your BigQuery budget. Here is the decision framework for getting dbt incremental models right — the first time.
dbt MERGE Strategy in BigQuery: Why It's Scanning Your Whole Table
dbt incremental models using the merge strategy in BigQuery can silently scan your entire target table on every run. Here's how to detect it and fix it fast.
Late-Arriving Data in dbt BigQuery: Fix Silent Metric Corruption
Late-arriving data silently corrupts dbt incremental models in BigQuery — producing wrong metrics that nobody catches until a decision has already been made. Here is how to fix it.
dbt Source Schema Drift: Find It Before It Breaks Production
dbt's default on_schema_change='ignore' silently drops new source columns from incremental models. Here's how to detect and fix it before your dashboards lie to you.