Skip to main content
Idle resources · Medium severity

Snowflake Warehouse Idle

A running warehouse consumes credits per second whether or not a query is executing, until auto-suspend stops it.

Free to start. No card. The playground just needs your work email.

Snowflakeprovider
Mediumseverity
Savingswhere it shows up
Manualfix, change spelled out

Snowflake

Found, explained, handed over.

Findings with a dollar figure attached, idle, oversized, orphaned, unscheduled and undiscounted spend.

01

Detect

ZopNight checks this automatically across Snowflake, with read-only access to the account.

02

Explain

Every finding says exactly what to change: Suspend the idle warehouse. Where the saving can be proven it is priced; where it cannot, the finding says so.

03

Fix

The finding opens with the change already spelled out, so the fix is one ticket, not an investigation.

Applies to
Snowflake Warehouse on Snowflake
Category
Idle resources. Resources running but doing no useful work: zero invocations, no connections, no traffic.
Where it appears
The Savings tab of Recommendations, with every affected resource listed.
Rule ID
RC-2101
Full reference

Snowflake Warehouse Idle

Related checks

See the idle resources in your account.

Connect a read-only role and the first pass runs on your own estate. This check, and the rest of the catalogue, with it.

Prefer to talk it through first? Book 20 minutes with the team.

  • $30M+annualised cloud spend under management
  • 550K+resources tracked since launch
  • 20-60%off the bill in the first month
  • SOC 2Type II report, plus ISO 27001

Figures published on zop.dev.

Multi-cloud automation· Production-ready in 30 min· SOC 2 · ISO 27001· 20–60% off the bill, first month· 4 platforms · 1 console· Multi-cloud automation· Production-ready in 30 min· SOC 2 · ISO 27001· 20–60% off the bill, first month· 4 platforms · 1 console·