Skip to main content

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)
Use CaseAuto-Suspend Value
BI dashboards5–60 sec
ETL / ELT60–300 sec
Ad-hoc analyst queries30 sec
Large ML workloads300–600 sec

🧩 Example​

CREATE WAREHOUSE my_wh
WITH WAREHOUSE_SIZE = 'MEDIUM'
AUTO_SUSPEND = 60;