Snowflake snippets

How to suspend a warehouse in Snowflake

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

ALTER WAREHOUSE MY_WAREHOUSE_NAME SUSPEND;
Snowflake snippet 30

You can check the warehouse status with the following query

SHOW WAREHOUSES LIKE 'MY_WAREHOUSE_NAME';
Snowflake snippet 29

Back to Snowflake cookbook page