Consumption & cost · rule tf-warehouse-never-suspends
Snowflake warehouses that never suspend
A Metacenta review checks this under the rule Warehouses suspend when idle. Everything below applies whether or not you ever commission one.
What this rule checks
From your Terraform files, this rule flags Snowflake warehouses whose auto_suspend is zero, which never suspends, or longer than one hour.
Why it matters
The warehouse keeps billing while nothing runs on it. An always-on warehouse is usually the largest avoidable line on a Snowflake invoice.
How to fix it
Let idle warehouses suspend. Set auto_suspend to between 60 and 300 seconds. Keep a warehouse running only for a workload that must never wait for it to resume.
Before:
resource "snowflake_warehouse" "transforming" {
name = "TRANSFORMING"
warehouse_size = "MEDIUM"
auto_suspend = 0
}
After:
resource "snowflake_warehouse" "transforming" {
name = "TRANSFORMING"
warehouse_size = "MEDIUM"
auto_suspend = 120
}
When it is fine to leave
A warehouse serving dashboards that must answer instantly, all day, may justify a longer suspend. Its local cache also survives while it runs. Make it a small warehouse, and a deliberate choice.
What we need to check it
The .tf files that declare your Snowflake warehouses. We read resource types, names and settings. A credential-shaped value is reported by line number, never copied.