© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024
A. CarruthersTuning the Snowflake Data Cloudhttps://doi.org/10.1007/979-8-8688-0379-6_6

6. Warehouses

Andrew Carruthers1  
(1)
Birmingham, UK
 

Virtual data warehouses, also called multicluster compute, are a first-order named object for a group (or cluster) of servers with multicore/hyperthreading CPU(s), memory, and temporary storage (SSD). Warehouses are massively parallel processing (MPP) engines.

Any running warehouse consumes compute credits; therefore, you should pay careful attention to right-sizing warehouses and their configuration. Not all queries require a running warehouse as some resolve their results directly from metadata or query cache, but for ...

Get Tuning the Snowflake Data Cloud: Optimizing Your Data Platform to Minimize Cost and Maximize Performance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.