Fintel Analyticsdbt Models Querying Partitioned BigQuery Tables Without Partition Filters
Your BigQuery tables are partitioned — but are your dbt models actually using those partitions? Here is how to find out and fix it before your bill does.
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 Partitioning & Clustering Mistakes Killing Your Bill
Partitioned tables don't automatically mean cheaper queries. Discover the six silent mistakes that bypass partition pruning in BigQuery — and exactly how to fix them before your next bill arrives.
dbt Cross-Dataset Joins in BigQuery: Fix the Silent Scan
When dbt models join across BigQuery datasets, partition pruning silently breaks — and your bill triples. Here's how to find and fix it.