Enabling Data Visualization in CDW

Learn how to add CDP Data Visualization to a virtual data warehouse.

  1. Log in to the CDP web interface and navigate to the Data Warehouse service.
  2. Locate your database catalog.
    1. In the Data Warehouse service, click Overview in the left navigation panel.
    2. On the Overview page, locate the database catalog you want to use and make sure it is running.
  3. Create a new virtual data warehouse with CDP Data Visualization enabled.

    If you already have a virtual data warehouse with the tool enabled, see Starting Data Visualization in CDW for information on how to launch Data Visualization.

    1. Click the plus icon in the top right corner of the Overview page.
      Alternatively, on the Virtual Warehouses page, click ADD NEW.
    2. In the New Virtual Warehouse dialog box, specify the following details:
      • Name – for the new virtual warehouse
      • Type – warehouse type (can be Hive or Impala)
      • Database Catalog – that the new warehouse should query
      • Size – the preferred compute capacity size
    3. [Optional] Configure auto-suspend anf auto-scaling settings.

      For consistently good response times, especially if you expect interactive style workloads throughout the day:

      Set AutoSuspend Timeout to a relatively high number or completely disable it by setting it to zero.
    4. Toggle the Enable Data Visualization button to install Cloudera Data Visualization with the virtual warehouse.

      If the Enable Data Visualization option is disabled in the New Virtual Warehouse dialog box, another virtual data warehouse already has the tool enabled for the same database catalog.

      You can identify which virtual data warehouse runs with CDP Data Visualization by the Data VIZ icon shown in the virtual warehouse instances on the Data Warehouse Overview page.

    5. Click CREATE to create the new virtual data warehouse.

Your new virtual data warehouse is created with CDP Data Visualization installed. The creation process takes anywhere between a few seconds and a few minutes depending on available resources in the environment.

Start Data Visualization in CDW