Multi-cluster warehouses
With multi - cluster warehouses, Snowflake supports allocating, either statically or dynamically, additional clusters to make a larger pool of compute resources available. A multi - cluster warehouse is defined by specifying the following…
Virtual warehouses
…warehousesMulti - cluster warehouses enable you to scale compute resources to manage your user and query concurrency needs as they change, such as during peak and off hours.
Warehouse considerations
The number of clusters (if using multi - cluster warehouses). The length of time the compute resources in each cluster runs. For example: X - Small: Bills 1 credit per full, continuous hour that each cluster runs; each successive size…
Overview of warehouses
Warehouses are required for queries, as well as all DML operations, including loading data into tables. In addition to being defined by its type as either Standard or Snowpark - optimized, a warehouse is defined by its size, as well as the…
Common considerations related to Virtual Warehouse credit consumption
Multi - cluster warehouses allow the scaling of compute resources to respond to changes in query and user concurrency. MCWs run in 'maximized' or 'auto - scale' mode.
Automatic Clustering, Materialized Views, & Automatic Maintenance In Snowflake
Snowflake’s automatic clustering feature is now available for all regions and clouds. Automatic clustering is a standard feature customers can enable by contacting Snowflake Support. With legacy on - premises and cloud data warehouses,…
How to find concurrent queries running on the same warehouse
ISSUE: Concurrent queries utilizing the same virtual warehouse can cause contention of resources such as CPU, Memory, and other key resources. This may potentially impact the performance of concurrent queries. SOLUTION: Snowflake's…
Feb 28, 2025: Increased max_cluster_count limits for multi-cluster warehouses
Currently, you must use a SQL command, not Snowsight, to specify an upper limit higher than 10. The scaling policies for multi - cluster warehouses now can increase or decrease the capacity of a warehouse by more than one cluster at a time.
WAREHOUSE_EVENTS_HISTORY view
This Organization Usage view can be used to return the events that have been triggered for the single - cluster and multi - cluster warehouses in your account. Supported events include: Creating, dropping, or altering a warehouse, including…
Snowflake Editions
Snowflake offers multiple editions to choose from, ensuring that your usage fits your organization’s specific requirements. Each successive edition builds on the previous edition through the addition of edition - specific features and/or…
Source