Question

A data engineering team runs a virtual warehouse that supports a BI dashboard used by hundreds of analysts each morning. During peak hours, individual queries complete quickly, but users report that many queries are queuing and waiting to start. The team wants to eliminate the queuing without over-provisioning during quiet periods. Which configuration change should they make?

Accepted Answer

Configure the warehouse as a multi-cluster warehouse in auto-scale mode (min/max clusters), so clusters start under load and shut down in quiet periods

Answer

Increase the warehouse size from Medium to X-Large to give each query more compute resources

Answer

Set a shorter auto-suspend time so the warehouse resumes fresh clusters more often

Answer

Enable clustering keys on the underlying tables to reduce query queuing