Virtual Warehouses

.

Related Topics

• Understanding Compute Cost

• Working with Resource Monitors

A virtual warehouse, often referred to simply as a “warehouse”, is a cluster of compute resources in Snowflake. A virtual warehouse is available in two types:

• Standard

• Snowpark-optimized

A warehouse provides the required resources, such as CPU, memory, and temporary storage, to perform the following operations in a Snowflake session:

• Executing SQL SELECT statements that require compute resources (e.g. retrieving rows from tables and views).

• Performing DML operations, such as:

  • Updating rows in tables (DELETE , INSERT , UPDATE).

  • Loading data into tables (COPY INTO <table>).

  • Unloading data from tables (COPY INTO <location>).

Note

To perform these operations, a warehouse must be running and in use for the session. While a warehouse is running, it consumes Snowflake credits.

Next Topics:

• Overview of Warehouses
• Snowpark-optimized Warehouses
• Warehouse Considerations
• Multi-cluster Warehouses
• Working with Warehouses
• Using the Query Acceleration Service
• Monitoring Warehouse Load