How to Schedule Snowflake Warehouses: Step by Step

Step-by-step guide to suspending and resuming Snowflake virtual warehouses on a schedule with ZopNight, so non-production compute stops billing credits overnight.

This is the practical version, the one you can follow in a single sitting. It starts read-only, touches no production resource by default, and every step is reversible, so there is no point at which you are committed to something you cannot undo. Budget about 10 minutes. Before you start you will want: A Snowflake account; Key-pair JWT or a personal access token; Warehouse usage visible in ACCOUNT_USAGE.

The steps

1. Connect Snowflake as a standalone account.
2. Review discovered warehouses.
3. Create a suspend and resume schedule.
4. Layer in warehouse recommendations.

Why this is safe to do today

The reason this is a low-stakes change is that nothing here is destructive. Scheduling stops and starts resources; it never deletes them, and your data persists across a stop exactly as it does across a normal reboot. Production is excluded by default, actions run in dependency order, and every state change is logged with what triggered it.

If you want the fuller context behind this task, the FinOps guide covers where it fits, and the AWS EC2 scheduling page shows the same loop applied to a specific resource.

Getting started

Getting started is intentionally low-stakes:

• Connect your cloud provider with a read-only role. Nothing is scheduled or changed at this stage.
• Let ZopNight discover your non-production resources and review exactly what it found, filtered by account, region, and status.
• Create a schedule in your timezone and attach the non-production resources or groups you want it to cover.
• Watch the first cycle run, with Slack, Teams, or Google Chat notifications on every start, stop, and failure, then layer in idle cleanup and guided rightsizing.

Production stays excluded by default throughout, and because discovery and recommendations are read-only, you can prove the value before you enable a single action.