Slow Snowflake dashboards aren't always slow queries. Often the query runs in two seconds but waits twenty in line because the warehouse is full. Here's a read-only query that shows which warehouses q
Pruning is the biggest performance lever in Snowflake. A query that scans 2% of a table's micro-partitions instead of 100% is often 10-50x faster on the same warehouse. This read-only query finds the
When a Snowflake query's intermediate results don't fit in warehouse memory, it spills: first to the warehouse's local SSD, then to remote cloud storage. Remote spill often makes a query 5-10x slower,
"Just make the warehouse bigger" is the most expensive way to tune Snowflake, and often it doesn't even work. A bigger warehouse speeds up the execution phase of a query. It does nothing for a query t