Six Snowflake audits in 2026 produced average savings of 47%. Here are the exact queries and settings that produce those numbers.
- 01Audit warehouse load history
Drop sizes where average load < 30%.
- 02Tighten auto-suspend by warehouse type
30-60s for interactive; 600s for batch.
- 03Find expensive recurring queries
Materialized views or query result caching.
- 04Adopt resource monitors per business unit
Hard suspend at 100% — never suggest, always enforce.
- 05Enable query timeout limits per role
Stops runaway queries from burning credits silently.
Resource Monitor SQL
CREATE OR REPLACE RESOURCE MONITOR rm_analytics
WITH CREDIT_QUOTA = 5000
FREQUENCY = MONTHLY
START_TIMESTAMP = IMMEDIATELY
TRIGGERS
ON 75 PERCENT DO NOTIFY
ON 90 PERCENT DO NOTIFY
ON 100 PERCENT DO SUSPEND
ON 110 PERCENT DO SUSPEND_IMMEDIATE;
ALTER WAREHOUSE analytics_wh SET RESOURCE_MONITOR = rm_analytics;Ready to optimize your cloud or AI footprint?
Book a free 30-minute architecture review. We will deliver a written cost-and-architecture audit within 48 hours.
Need help with reduce Snowflake spend?
Ohveda runs free 30-minute architecture reviews. We will identify your top opportunities in writing within 48 hours — at no cost.