Snowflake - Creating warehouse in Snowflake

Creating warehouse

Login to Snowflake and click on warehouse and click on Create

fill the necessary details and click Finish

We can also create warehouse using SQL in worksheets, the typical SQL looks like below

 

CREATE WAREHOUSE LEARN_WH WITH WAREHOUSE_SIZE = 'XSMALL' WAREHOUSE_TYPE = 'STANDARD' AUTO_SUSPEND = 600 AUTO_RESUME = TRUE MIN_CLUSTER_COUNT = 1 MAX_CLUSTER_COUNT = 2 SCALING_POLICY = 'STANDARD' COMMENT = 'LEARNING WAREHOUSE';