Bird
Raised Fist0
SnowflakeHow-ToBeginner · 3 min read

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 START instead of RESUME — Snowflake uses RESUME to 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

CommandDescription
ALTER WAREHOUSE RESUME;Starts a suspended warehouse
ALTER WAREHOUSE SUSPEND;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.