An M-sized warehouse, an auto-suspend timer at 60 minutes, and a scheduler firing every 55.
A finance team scheduled a light hourly refresh against a Snowflake warehouse sized
Medium (4 credits per hour). The warehouse was created with the default 10-minute
auto-suspend, then bumped to 60 minutes "to keep the cache warm". The scheduler ran
every 55 minutes. Net effect: the warehouse never suspended. It billed continuously
for weeks, for a job that used roughly 90 seconds of actual compute per run. The fix
was two settings changes: AUTO_SUSPEND = 60 and downsize to Small. Same
query performance, roughly one-tenth the credits.
Grounded in: Snowflake, Warehouse considerations (docs.snowflake.com). Pattern documented at Select, Snowflake Cost Optimization (select.dev).