Use the Max Clusters drop-down to adjust the maximum number of clusters. If you are converting to a multi-cluster warehouse, turn on the Multi-cluster Warehouse option. To convert an existing warehouse to a multi-cluster warehouse or to increase the maximum number of clusters for an existing warehouse: Once the timer is up, start connecting and log in. The fix is to simply wait things out until it’s your turn to enter the game. Indeed, it’s a server-side issue and has nothing to do with your connection or anything else on your end. You can also use the CREATE WAREHOUSE command. Instead, it means that there’s a waiting line to get into the game. To create new warehouses to which queries can be distributed, sign in to Snowsight and select Admin » Warehouses. See ‘Meaning & use’ for definitions, usage, and quotation evidence.

How to configure warehouses to reduce queues ¶ Regular Warehouses : There are ten meanings listed in OEDs entry for the noun queue, four of which are labelled obsolete. This might result in queries being queued and taking longer to complete. Rather than starting additional clusters. The Economy scaling policy favors conserving credits over cluster elasticity by keeping running clusters fully-loaded If you are running a multi-cluster warehouse in Auto-scale mode, you can use a scaling policy to helpĬontrol the costs. If you are already using a multi-cluster warehouse, increase the maximum number of clusters.įor a description of how running a multi-cluster warehouse affects credit consumption, refer to Multi-cluster size and credit usage. Provision additional compute resources when demand spikes.

If specific queries are causing usage spikes, focus on moving those queries.Ĭonsider converting a warehouse to a multi-cluster warehouse so the warehouse can elastically not a multi-cluster warehouse), consider creating additional warehouses, and then distribute the queriesĪmong them.

In your queue meaning