Multi-cluster Warehouses

Overview

Multi-cluster Warehouses (MCW) provide an automated way to scale out compute resources to handle concurrent user requests. They are essential for environments with unpredictable or highly variable query volumes, preventing queries from queuing during peak hours.

Key Concepts

What is a Multi-cluster Warehouse?

An MCW allows a single virtual warehouse to spawn additional identical clusters automatically when the current cluster(s) cannot handle the incoming query load.