Top TasksPDF version

Activating an environment in Cloudera Data Warehouse on cloud

An environment is a logical entity that represents the association of your on cloud user account with the compute resources. After you register your OpenShift Container Platform (OCP) or Cloudera Embedded Container Service environment with Cloudera, activate the environment in Cloudera Data Warehouse to set up a Database Catalog and create Virtual Warehouses. Activating an environment causes Cloudera to connect to the Kubernetes cluster, which provides the computing resources for the Database Catalog. This is the first step in setting up Cloudera Data Warehouse.

  1. Log in to the Cloudera Data Warehouse service as an DWAdmin.
  2. Go to the Environments tab, locate the environment that you want to activate, and click Activate.
  3. Specify the storage class name and click Activate.

    For local caching, ensure that the platform administrator uses the Local Storage Operator to create a local file system on an SSD/NVMe for each OpenShift worker node and then mounts it to a known location on the worker node. Make sure that this local caching location allows temporary data to be stored in a way that supports performance.

  1. Log in to the Cloudera Data Warehouse service as an DWAdmin.
  2. Go to the Environments tab, locate the environment that you want to activate, and click Activate.
  3. Select the resource pool and other options as needed, and click Activate.

A default database Catalog is automatically created when you activate an environment in Cloudera Data Warehouse. After the Database Catalog is created, you can create Hive, Impala, or Impala Virtual Warehouses with the Unified Analytics mode.

If Analysts in your organization use JDBC or ODBC SQL clients, then you can download the drivers from the Cloudera Data Warehouse UI and connect them to the Virtual Warehouses. Analysts can also use Hue, the built-in SQL editor to query and explore data.

You can also link to Cloudera Data Visualization instance from the Cloudera Data Warehouse UI which line of business users can use to visualize data and gain insights.

We want your opinion

How can we improve this page?

What kind of feedback do you have?