Data Warehouses for the Snowflake SnowPro Core Certification

Tenth Chapter: Data Warehouses

Gonzalo Fernandez Plaza
6 min readSep 28, 2021
Chapter 10 of the Snowflake SnowPro Core Certification Course. Data Warehouses.
Chapter 10 of the Snowflake SnowPro Core Certification Course. Data Warehouses.

Data warehouses in Snowflake are one of the most important parts of this technology, and as we discussed in previous chapters, they will allow us to compute. In this chapter, we are going to see them in more detail:

  1. Warehouses in Snowflake
  2. Properties from the warehouses
  3. Typical certification questions about Snowflake warehouses

Remember that all the chapters from the course can be found in the following link:

WAREHOUSES IN SNOWFLAKE

A Data Warehouse is a cluster of computing resources in Snowflake. It provides the required resources, such as CPU, memory, and temporary storage, to perform queries and DML operations (like loading data into tables). A warehouse must be running and in use for the session to perform these operations. While a warehouse is running, it consumes Snowflake credits.

--

--

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com