Adding a new Virtual Warehouse

A Virtual Warehouse is an instance of compute resources in Public Cloud that is equivalent to an on-prem cluster. You learn how to create a new Virtual Warehouse in Cloudera Data Warehouse (CDW) Public Cloud.

A Virtual Warehouse provides access to the data in tables and views in the data lake your Database Catalog uses. A Virtual Warehouse can access only the Database Catalog you select during configuration.

In this task and subtasks, you configure Virtual Warehouse features, including performance-related features for production workloads, such as the Virtual Warehouse size and auto-scaling. These features are designed to manage huge workloads in production, so if you are evaluating CDW, or just learning, simply accept the default values. This task covers the bare minimum.

In subtopics, you see how to configure features for production workloads, such as Hive query isolation and Impala catalog high availability.

Optionally, in AWS environments, you can select an availability zone. All compute resources run will run in the selected zone.
  • You obtained permissions to access a running environment for creating a Virtual Warehouse.
  • You obtained the DWAdmin role to perform Data Warehouse tasks.
  • You logged into the CDP web interface.
  • Your activated the environment from Cloudera Data Warehouse.
For more information about meeting prerequisites, see Creating your first Virtual Warehouse.
  1. Navigate to > Data Warehouse > Virtual Warehouses > Add New.
  2. In New Virtual Warehouse, specify a Name, its Type (Hive or Impala), which Database Catalog to query.
  3. Select the Hive or Impala type of Virtual Warehouse you want.
    Virtual Warehouses can use Hive or Impala as the underlying SQL execution engine. Typically, Hive is used to support complex reports and enterprise dashboards. Impala is used to support interactive, ad-hoc analysis.
  4. In AWS environments only, accept the default availability zone, or select an availability zone, such as us-east-1c.
    The default behavior is to randomly select an availability zone from the list of configured availability zones for the associated environment. Generally, it is fine to accept the default.
  5. Optionally, select Enable SSO to enable single sign-on to your Virtual Warehouse, and in User Groups, select a user group set up in advance to access endpoints. If you do not have a user group set up for SSO, do not select Enable SSO.
    In Management Console > User Managementyou set up a user group, required for enabling SSO, that identifies the users authorized to access to this Virtual Warehouse.
  6. Optionally, enter keys and values for Tagging the Virtual Warehouse.
  7. Select the Size of the Virtual Warehouse as described in the next subtopic.
    The AutoSuspend and Autoscaling controls appear.
  8. Configure auto-scaling as described in the subsequent subtopic.
  9. Select the Hive Image Version or the Impala Image Version version, and the Hue Image version you want to use, or accept the default version (latest) at the top of the drop-down menus.
    For example


  10. Accept default values for other settings, or change the values to suit your use case, and click Create to create the new Virtual Warehouse.
    Click the tooltip for information about settings.
    When you create a Virtual Warehouse, a cluster is created in your cloud provider account. This cluster has two buckets. One bucket is used for managed data and the other is used for external data.