Tuning Virtual Warehouses

After creating a Virtual Warehouse, you can change the auto-scaling and some other configurations.

You set the auto-suspend timeout, the minimum and maximum number of executors for your virtual cluster, when your cluster should scale up and down, and other configurations.

Required role: DWAdmin

  1. Log in to the CDP web interface and navigate to the Data Warehouse service.
  2. In the Data Warehouse service, click Overview in the left navigation pane.
  3. In the Overview page under Virtual Warehouses, find your Virtual Warehouse, click , and select Edit.
  4. In SIZING AND SCALING, view the properties you can adjust to tune auto-scaling.
  5. Configure auto-scaling as described in Creating a Virtual Warehouse.
  6. Click Apply in the upper right corner of the page to apply your changes.