Auto-Suspend & Auto-Resume in Virtual Warehouses
Snowflake Virtual Warehouses operate on a pay-as-you-use model.
This means compute runs only when needed β and you should not pay when itβs idle.
To optimize cost, Snowflake provides two key features:
π΄ 1. Auto-Suspend β Stop Paying When Warehouse is Idle
Auto-Suspend automatically pauses a warehouse after a specified period of inactivity.
β Business Explanationβ
If no one is running queries, Snowflake shuts down the engine automatically so you stop paying.
π§ Technical Behaviorβ
- Warehouse enters SUSPENDED state
- No credits are consumed in suspended mode
- Storage remains accessible
- Connections remain valid (just wait for resume)
π Recommended Auto-Suspend Valuesβ
| Use Case | Auto-Suspend Value |
|---|---|
| BI dashboards | 5β60 sec |
| ETL / ELT | 60β300 sec |
| Ad-hoc analyst queries | 30 sec |
| Large ML workloads | 300β600 sec |
π§© Exampleβ
CREATE WAREHOUSE my_wh
WITH WAREHOUSE_SIZE = 'MEDIUM'
AUTO_SUSPEND = 60;