Creating a tailored multi-cluster virtual warehouse
While creating a standard virtual warehouse is a straightforward affair, configuring a virtual warehouse that the standard options have been customized for can be a slightly more involved process. In this recipe, we will create a new multi-cluster virtual warehouse and set the scaling configuration so that the virtual warehouse can scale up and down on demand. We will also configure some advanced parameters to allow a higher number of concurrent queries to be executed.
Getting ready
To create a multi-cluster virtual warehouse, you must have the Enterprise or higher edition of Snowflake. If you run the following statements on a lower edition, you will likely receive an error stating 'MULTI_CLUSTER_WAREHOUSES' not enabled. Your user should have the SYSADMIN role or higher since the SYSADMIN (or the even higher ACCOUNTADMIN) role can create a virtual warehouse.
How to do it…
Log into either the Snowflake...
