Fintel AnalyticsSnowflake 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.
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
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.
BigQuery Join Skew in dbt Models: Find & Fix It in 2026
BigQuery join skew silently inflates your bill and stalls dbt runs. Here is how to find it, fix it, and stop it coming back.
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.
BigQuery Shuffle Joins in dbt: Fix the Hidden Cost in 2026
Shuffle joins in BigQuery dbt models are one of the most costly and least visible performance problems a data team can have. Here is how to find and fix them.
Network Token Analytics: Fix Your Payment Performance Data
Network tokens promise higher auth rates and lower fraud — but most fintechs can't measure whether they're delivering. Here's how to build the analytics layer that proves it.
Loan Portfolio Analytics for Fintech Lenders: Build It Right in 2026
Most fintech lenders drown in loan data but lack a single trusted view of portfolio performance. Here's how to build the analytics stack that actually works.
Cloud Data Warehouse Cost Optimisation: A 2026 Guide
Cloud data warehouse bills spiralling out of control? This practical guide covers the strategies, tools, and decisions that help businesses cut costs without sacrificing performance.