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.
8 of 206 posts
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.
SELECT * in dbt BigQuery Models: The Silent Cost Multiplier
SELECT * in dbt BigQuery models is one of the quietest cost drivers in a growing data stack. Here's how to find every offending model and fix it.
BigQuery Window Functions Without PARTITION BY: The Silent Cost Killer
A missing PARTITION BY in a BigQuery window function can silently scan millions of rows it never needed — and you won't see it until the invoice arrives. Here's how to find and fix it.
Snowflake Automatic Clustering Cost: Find Tables Burning Credits
Serverless reclustering credits hide outside your warehouse bill. Run these SQL queries to find which dbt tables burn them and how to stop it.
Snowflake Query Spilling to Remote Storage: Find & Fix It
Remote spill is the slowest, costliest way a Snowflake query can run. Here is the SQL to find every spilling query and dbt model, and how to fix them.
Snowflake Idle Warehouse Cost: Find the Credits You're Burning
Your Snowflake bill may be paying for warehouses that run nothing. Here is the SQL to measure idle credits per warehouse, fix auto-suspend and stop it coming back.
dbt Query Labels in BigQuery: Fix Your Cost Attribution (2026)
Your BigQuery bill spiked and you have no idea which dbt model caused it. Here is how to fix that with dbt query labels — and the diagnostic SQL to prove it.