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

Nicola Simboli

Nicola Simboli Senior Analytics Engineer

15+ years across SaaS, enterprise and consulting. Focused on scalable data platforms, metric reliability and analytics systems that teams actually use.

Back to Snowflake cookbook page