Set up a data connection manually

Data connections are automatically discovered. You can also set up a data connection manually, which works across CDP environments.

  1. Log into the CDP web interface and navigate to the Data Warehouse service.
  2. In the Data Warehouse service, select Virtual Warehouses in the left navigation panel.
  3. Select the options menu for the warehouse you want to access, and select Copy JDBC URL.
  4. In Site Administration > Data Connections, select New Connection.
  5. Enter the connection name. You cannot have duplicate names for data connections within a workspace or within a given project.
  6. Select the connection type:
    1. Hive Virtual Warehouse
    2. Impala Virtual Warehouse
  7. Enter the JDBC URL for the data connection. You can obtain this from the virtual warehouse in Cloudera Data Warehouse.
  8. (Optional) Enter the Virtual Warehouse Name. This is the name of the warehouse in Cloudera Data Warehouse.
The data connection is available to users by default. To change availability, click the Available switch.