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 
WAREHOUSE_SIZE=LARGE 
INITIALLY_SUSPENDED=TRUE;

You can check the warehouse status with the following query

SHOW WAREHOUSES LIKE 'MY_WAREHOUSE_NAME';