How to Start a Warehouse in Snowflake: Simple Steps
To start a warehouse in Snowflake, use the
ALTER WAREHOUSE <warehouse_name> RESUME; command. This command activates the warehouse so it can process queries and tasks.Syntax
The command to start a warehouse in Snowflake is:
ALTER WAREHOUSE <warehouse_name> RESUME;: This resumes a suspended warehouse, making it active and ready to process queries.
Replace <warehouse_name> with the name of your warehouse.
sql
ALTER WAREHOUSE my_warehouse RESUME;Example
This example shows how to start a warehouse named my_warehouse. First, the warehouse is suspended, then it is resumed to start it.
sql
ALTER WAREHOUSE my_warehouse SUSPEND; -- Warehouse is now suspended and not processing queries ALTER WAREHOUSE my_warehouse RESUME; -- Warehouse is now active and ready to use
Output
Statement executed successfully.
Statement executed successfully.
Common Pitfalls
Common mistakes when starting a warehouse include:
- Trying to start a warehouse that does not exist, which causes an error.
- Using
STARTinstead ofRESUME— Snowflake usesRESUMEto start suspended warehouses. - Not having the right permissions to alter the warehouse state.
Always check the warehouse name and your permissions before running the command.
sql
/* Wrong command - will cause error */ ALTER WAREHOUSE my_warehouse START; /* Correct command */ ALTER WAREHOUSE my_warehouse RESUME;
Quick Reference
| Command | Description |
|---|---|
| ALTER WAREHOUSE | Starts a suspended warehouse |
| ALTER WAREHOUSE | Stops a running warehouse to save costs |
| SHOW WAREHOUSES; | Lists all warehouses and their states |
Key Takeaways
Use ALTER WAREHOUSE RESUME; to start a suspended warehouse.
Ensure the warehouse exists and you have permission before starting it.
RESUME is the correct keyword, not START.
Suspending warehouses when not in use saves costs.
Check warehouse status with SHOW WAREHOUSES; before and after starting.
