Snowflake snippets

How to resume a warehouse in Snowflake

If you want to resume a warehouse in Snowflake you can just use the following query

ALTER WAREHOUSE MY_WAREHOUSE_NAME RESUME;
Snowflake snippet 30

You can check the warehouse status with the following query

SHOW WAREHOUSES LIKE 'MY_WAREHOUSE_NAME';
Snowflake snippet 31

Back to Snowflake cookbook page