In Snowflake, a virtual warehouse, often known as a "warehouse
," is a collection of computational resources. A virtual warehouse provides the resources required for the users like CPU
, memory, and temporary storage to perform multiple Snowflake operations:
Execute the SQL SELECT
statements that necessitate the use of computing resources (e.g. retrieving rows from tables and views).
DML operations include :
* Updating table rows (DELETE , INSERT , UPDATE
).
* Data Loading into tables (COPY INTO <table>
).
* Data unloading from tables (COPY INTO <location>
).