From the course: Using Snowflake with Tableau
Join today to access over 24,800 courses taught by industry experts.
Tuning and scaling warehouses
From the course: Using Snowflake with Tableau
Tuning and scaling warehouses
- Whether you're managing small workloads or handling massive, unpredictable spikes in queries, Snowflake's warehouse configurations give you the flexibility to optimize your specific needs. First, let's briefly cover how Snowflake's virtual warehouses work. A warehouse in Snowflake is essentially a cluster of compute resources. Whenever you run queries, the warehouse allocates resources to execute them. By default, a warehouse operates as a single cluster warehouse. Meaning, it uses a fixed number of compute resources. However, when the demand grows, whether that's more users or more complex queries, the single cluster might not be sufficient, causing delays or queries to queue up. This is where multi-cluster warehouses come into play. Multi-cluster configurations allow Snowflake to dynamically allocate additional compute resources to handle increasing demand, ensuring that queries continue running efficiently even when the load spikes. Now let's dive into two primary scaling modes…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.