Fintel AnalyticsSnowflake Warehouses With No Resource Monitor: Find Them
Find every Snowflake warehouse running with no credit cap using runnable SQL, then set sensible quotas and stop the gap coming back.
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 206 posts
Snowflake ACCOUNTADMIN Audit: Who Has It and Who Uses It?
Too many people, and too many dbt jobs, run as ACCOUNTADMIN. Use these Snowflake queries to find them and fix it safely.
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 Time Travel Storage Cost: Find Bloated Tables
Your active data is flat but Snowflake storage keeps climbing. Here is the SQL to find the tables responsible, and the dbt config that fixes it.
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.
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.
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.