Why virtual warehouses control compute independently in Snowflake - See It in Action

Why Virtual Warehouses Control Compute Independently

📖 Scenario: You are working with Snowflake, a cloud data platform. Snowflake uses virtual warehouses to run queries and process data. Each virtual warehouse controls its own compute resources independently. This helps manage workloads efficiently.

🎯 Goal: Build a simple Snowflake setup that shows how to create multiple virtual warehouses with independent compute settings.

📋 What You'll Learn

Create a virtual warehouse named WH_SMALL with size SMALL

Create a virtual warehouse named WH_LARGE with size LARGE

Set the auto-suspend time to 300 seconds for both warehouses

Set the auto-resume feature to true for both warehouses

💡 Why This Matters

🌍 Real World

Virtual warehouses let companies run many data queries at once without waiting. Each warehouse can be sized and paused independently to save money and speed up work.

💼 Career

Cloud engineers and data analysts use virtual warehouses to optimize data processing and control costs in Snowflake environments.

1

Create the first virtual warehouse

Write a Snowflake SQL command to create a virtual warehouse called WH_SMALL with size SMALL.

Snowflake

-- Create virtual warehouse WH_SMALL with size SMALL
-- Your code here

Need a hint?

Use CREATE WAREHOUSE followed by the warehouse name and size.

2

Create the second virtual warehouse

Write a Snowflake SQL command to create a virtual warehouse called WH_LARGE with size LARGE.

Snowflake

CREATE WAREHOUSE WH_SMALL WITH WAREHOUSE_SIZE = 'SMALL';
-- Create virtual warehouse WH_LARGE with size LARGE
-- Your code here

Need a hint?

Repeat the create warehouse command with the new name and size.

3

Set auto-suspend for both warehouses

Write Snowflake SQL commands to set the auto-suspend time to 300 seconds for both WH_SMALL and WH_LARGE warehouses.

Snowflake

CREATE WAREHOUSE WH_SMALL WITH WAREHOUSE_SIZE = 'SMALL';
CREATE WAREHOUSE WH_LARGE WITH WAREHOUSE_SIZE = 'LARGE';
-- Set auto-suspend to 300 seconds for WH_SMALL and WH_LARGE
-- Your code here

Need a hint?

Use ALTER WAREHOUSE to change settings after creation.

4

Enable auto-resume for both warehouses

Write Snowflake SQL commands to enable auto-resume for both WH_SMALL and WH_LARGE warehouses.

Snowflake

CREATE WAREHOUSE WH_SMALL WITH WAREHOUSE_SIZE = 'SMALL';
CREATE WAREHOUSE WH_LARGE WITH WAREHOUSE_SIZE = 'LARGE';
ALTER WAREHOUSE WH_SMALL SET AUTO_SUSPEND = 300;
ALTER WAREHOUSE WH_LARGE SET AUTO_SUSPEND = 300;
-- Enable auto-resume for WH_SMALL and WH_LARGE
-- Your code here

Need a hint?

Use ALTER WAREHOUSE to enable auto-resume by setting it to TRUE.