Discovering the Connection Explorer interface

Learn how you can navigate to the Connection Explorer Interface and use it to connect to data in CDP Data Visualization.

  1. On the main navigation bar, click Data.

    The Data view appears, open on the Datasets tab.

  2. In the main area, click the Connection Explorer tab.

    The Connection Explorer interface appears. In this view, you can click a connection in left navigation that you want to explore and select a database. You can also select a specific table from that database, and explore its details.

    The Connection Explorer interface contains the following items:

    1. New Connection is for connecting to any source of data.
    2. New Dataset is for creating datasets, which are necessary for developing dashboards and visuals. You can also use start a new dataset from a specified table.
    3. For SQLite connections, the Add Data option enables you to introduce data that enriches your datasets from outside sources.
    4. The Supplemental menu, under the (ellipsis) icon, opens new options.
      1. For Impala connections, clicking the Clear result cache option under the supplemental menu forces a reload of the full table definition.
      2. Import Visual Artifacts option under the supplemental menu enables you to restore or import visual artifacts from a back-up *.json file.
      3. >_ Direct Access enables you to access data directly by running SQL queries. You can build datasets from specific SQL queries, as opposed to starting with an existing table.
    5. The Datasets tab lists all existing datasets on the connection.
    6. The Connection Explorer tab (current) enables you to explore the databases and tables available on the connection, and to manage all functions related to the data on the connection.
    7. The databases area of the screen shows all databases that you can access through the current connection. In our example, there is one called main (selected). Selecting a database shows its tables.
    8. In the list of tables, the # Datasets column lists the number of datasets that use the particular table as their initial definition.
    9. You can click New Dataset to create a dataset on a specific table.