CODEWITHSUNDEEP
snowflake-cloud-data-platformwarehouse
Siver R
Siver R

Reputation: 3

How can I use the warehouse?

I have done the following steps:

Since I did not find any information about the warehouse functionality, I wanted to ask you guys the following: What exactly is the use the warehouse in these steps at all? Or are there any other steps after loading data into the database for example loading data into the warehouse?

Upvotes: 0

Views: 425

Answers (2)

Nathan Griffiths
Nathan Griffiths

Reputation: 12756

This is a common confusion due to the slightly bizarre way Snowflake have used the term "warehouse". The key thing to remember is that in Snowflake a "warehouse" represents a compute resource. It has nothing to do with data storage, which is entirely separate from the compute resource.

The separation of compute and data storage is one of the keys strengths of the Snowflake platform as it enables you to have multiple, differently scaled compute resources ("warehouses") for different tasks (e.g. data transformation, reports) that all share the same data storage.

Upvotes: 0

Lukasz Szozda
Lukasz Szozda

Reputation: 175566

The documentation provides detailed description of Virtual Warehouses:

A virtual warehouse, often referred to simply as a “warehouse”, is a cluster of compute resources in Snowflake. 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 ).

  • Unloading data from tables (COPY INTO ).

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.

Upvotes: 1

Related Questions