Fintel AnalyticsBigQuery INFORMATION_SCHEMA Cost Attribution: Stop the Guessing
Your BigQuery bill is growing but you can't pinpoint why. INFORMATION_SCHEMA has the answer — here's how to use it to attribute costs by user, model, and team before it's too late.
Fintel Analytics blog
Data & AI Insights
Expert perspectives on data analytics, AI agents, internal tools, and business intelligence from the Fintel Analytics team.
7 of 207 posts
BigQuery Streaming Inserts Cost: Find What's Driving the Bill
Streaming ingestion is the BigQuery line item nobody budgets for. Run two INFORMATION_SCHEMA queries to find the tables behind it, then cut the cost.
BigQuery Scheduled Query Costs: Find the Query Wrecking Your Bill
A single misconfigured scheduled query can scan hundreds of TB before anyone notices. Here is how to find it — and fix it — in under five minutes.
BigQuery referenced_tables: Find dbt Models Scanning Ghost Tables
dbt models can silently scan BigQuery tables that never appear in your DAG. Here's how to find them in under five minutes using INFORMATION_SCHEMA.JOBS.
Repeated Subqueries in dbt BigQuery: Stop Paying Twice (2026)
Repeated subqueries in dbt BigQuery models silently scan the same large table multiple times per run — find them with INFORMATION_SCHEMA and fix them today.
dbt Sources With No Freshness Config: Find Them in BigQuery
Every dbt source without a freshness config is a silent risk. Here's how to find every unchecked source in under five minutes using BigQuery INFORMATION_SCHEMA — and how to fix it.
PII Sitting Unmasked in BigQuery: How to Find It Fast
Unmasked PII in BigQuery is a compliance and security risk most teams discover too late. Here's how to find it in under five minutes using SQL against INFORMATION_SCHEMA.