Snowflake Online Training

 

Snowflake Online Training

As Warehouse is important for computing. Let's discuss about how to create warehouse, alter it and view details of warehouse.

Snowflake provides two ways to create/modify/view warehouses – first way is UI and the another one is SQL statements.

Working on Warehouses using Snowflake's UI

Let's start with creating a warehouse −

Create Warehouse

Login into Snowflake using unique URL. Click Warehouses present at top ribbon as shown in the following screenshot −

It navigates to the next screen. Click Create above the list of warehouses as shown in the below.

It opens the Create warehouse dialog box. The following fields should be entered to create a warehouse.

·         Name − test_WH

·         Size − Small

·         Set Auto-Suspend to 5 minutes

Then click the Finish button.

Snowflake provides the facility to modify or alter the Warehouses based on the requirements. For example, after creation and usage, user can update warehouse size, clusters, suspension time.

Click the Warehouse button present at the top ribbon. It displays the warehouse page details. Select the warehouse that requires to be altered from the list of warehouses.

 

Contact us +91-9989971070.

Register now for Snowflake Online Training

Visit: https://www.visualpath.in/snowflake-online-training.html