Fintel AnalyticsNon-Deterministic Functions in dbt BigQuery: Why Your Cache Never Hits
Non-deterministic SQL functions silently bust BigQuery's query cache across your entire dbt DAG. Here is how to find every offending model and fix it fast.
Fintel Analytics blog
Data & AI Insights
Expert perspectives on data analytics, AI agents, internal tools, and business intelligence from the Fintel Analytics team.
3 of 206 posts
BigQuery Query Cache Invalidation in dbt: Why Your Cache Never Hits
BigQuery offers free query result caching — but most dbt projects silently invalidate it on every run. Here's exactly why it breaks and how to fix it.
JavaScript UDFs in dbt BigQuery: The Slot Cost You're Missing
JavaScript UDFs in dbt BigQuery silently consume disproportionate slot resources and block query cache hits. Here is how to find them, audit their cost, and fix them before they wreck your bill.