Explanation
Why the waste happens and who it affects.
Tightening the auto-suspend window ensures that the warehouse shuts down quickly once queries complete, minimizing credit waste while maintaining acceptable user experience (e.g., caching needs, interactive performance).
Billing model
The pricing dimensions that drive this cost.
- Virtual warehouses consume Snowflake credits at an hourly rate set by warehouse size; each size step up roughly doubles the credits charged per hour
- Credits are billed per second while a warehouse is running, with a 60-second minimum each time the warehouse starts or resumes
- A suspended warehouse consumes no credits, so the auto-suspend setting determines how long an idle warehouse keeps billing after its last query finishes
How to detect
4 checks to find it in your estate.
- Review auto-suspend settings for each warehouse to identify configurations with unnecessarily high idle time thresholds (e.g., exceeding 5 minutes).
- Analyze query frequency and typical idle patterns to evaluate whether warehouses could be suspended sooner without materially impacting performance.
- Confirm whether workloads rely heavily on caching benefits for user facing workloads, which may justify slightly longer suspend timers.
- Validate proposed changes with application teams to ensure that faster auto-suspend does not introduce unacceptable query latency.
How to fix
5 ways to remove the waste.
- Adjust warehouse auto-suspend settings to minimize idle billing while balancing performance needs.
- For batch and non-interactive workloads, consider shorter suspend intervals (e.g., around 60 seconds), recognizing that minimum billing granularity is already 60 seconds.
- For interactive workloads where query caching significantly improves performance, moderate suspend timers (e.g., up to 5 minutes) may be justified.
- Communicate cache loss implications to workload owners to ensure informed decisions about suspend timing.
- Periodically reassess suspend policies as workload patterns and user experience expectations evolve.
Documentation
Vendor references for pricing and configuration.