Data connections allow you to integrate and interact with various data sources. If your
data source changes or you need to switch between different connection types (for example from
Impala to Hive), you can update an existing connection instead of creating a new one. This
ensures continuity in your datasets and dashboards while minimizing configuration efforts. Learn
how to edit the basic settings of an existing data connection in Cloudera Data Visualization.
The following example shows changing an Impala connection to a Hive connection.
On the main navigation bar, click DATA.
The Data view appears, open on the
Datasets tab.
In the side bar, click the Edit button to the right of the
connection you want to change.
The Edit Data Connection modal window appears.
Edit the connnection details according to the connection type change you want to
implement.
If you are editing the Virtual Warehouse of an existing Cloudera Data Warehouse
Impala or Hive connection, the following scenarios apply:
Previously saved warehouse is still running:
The connection remains valid, and the warehouse appears as an available option in
the dropdown.
Previously saved warehouse no longer exists:
An alert notifies you that the previously saved Virtual Warehouse is no longer
available.
Previously saved warehouse exists, but details have changed:
An alert lists the fields that have changed. Click SYNC to
update the connection and ensure proper functionality.
At the bottom of the modal, click TEST.
If the connection is verified, click SAVE.
After the operation succeeds, the name of the new type of
connection appears on the side navigation bar.