How to create a warehouse in Snowflake (initially suspended)
Snowflake usually creates new warehouses already in a resume status, if you want to create it in a suspended status you can just use the following query.
CREATE OR REPLACE WAREHOUSE MY_WAREHOUSE_NAME
You can check the warehouse status with the following query
SHOW WAREHOUSES LIKE 'MY_WAREHOUSE_NAME';