Creating a CDW data connection in Data Visualization

Learn how to connect to data when using Cloudera Data Visualization in Cloudera Data Warehouse (CDW) data service. You can connect Data Visualization to a Virtual Warehouse to visualize your data. Similar to using a BI client, you can configure and connect to Virtual Warehouses from different clusters.

You must connect to your data prior to using the data modeling and visualization functions. You make the connection to the Virtual Warehouse when you select your warehouse in the steps below. The CDW Warehouse URL has the same compute instance ID as your Virtual Warehouse.

When you create a connection, you automatically gain privileges to create and manage datasets associated with this connection, and to build dashboards and visuals within these datasets.

  • For more information on the Manage data connections privilege, see RBAC permissions.
  • For instructions on how to define privileges for a specific role, see Setting role privileges.
  • For instructions on how to assign the administrator role to a user, see Promoting a user to administrator.

When you are creating a Hive or Impala data connection within the same cluster, the connection is considered secure and trusted, and the connection details can be auto-populated with a default authentication user.

  1. Start Data Visualization from the left navigation panel in CDW.
  2. On the main navigation bar, click DATA.
    The DATA interface appears, open on the Datasets tab.
  3. In the side menu bar of DATA, click NEW CONNECTION.
    The Create New Data Connection modal window appears.
  4. In Connection type, select CDW Hive or CDW Impala, and provide a name for your connection.
  5. Select a CDW Warehouse to connect to.
    The following fields are auto-populated:
    • Hostname or IP address
    • Port #
    • Username

    Enter the following information:

    • Hostname or IP address
    • Port #
    • Username
    • Password
  6. Click the Advanced tab and configure the additional details.
  7. Click TEST.
    If the connection is valid, the system returns a Connection Verified message.
  8. Click CONNECT.
You can create a data set, and then start creating visuals, dashboards, and applications. For more information, see Creating datasets and Creating a visual.