Virtual Warehouses¶
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:
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: