Cloudera Data Visualization, Data interface

The information and functionalities available on the DATA interface of Data Visualization enable you to manage the data you need for your visualizations and to initiate a number of operations when working with datasets.

The DATA interface shows your existing data connections. You can also add new connections to data sources, create new datasets, and work with your data tables. The interface has the following main parts:
  1. Data top menu bar
  2. Data side menu bar
  3. Data preview area

Data top menu bar

  1. The NEW DATASET button is for creating datasets. Datasets are needed for developing dashboards and visuals. You can also start a new dataset from a specified table.

  2. For SQLite connections, the ADD DATA button enables you to introduce data from outside sources to enrich your datasets.

  3. The Supplemental menu provides access to additional functions:
    • Clear result cache forces a reload of the full table definition.
    • Import Visual Artifacts enables you to restore or import visual artifacts from a backup JSON file.
    • Direct Access lets you access data on the connections directly and build datasets from specific SQL queries, as opposed to starting with an existing table.

Data side menu bar

  1. The NEW CONNECTION button is for connecting to any source of data.

  2. You can list all your datasets by clicking All Connections.

  3. samples is the SQLite connection that contains the example datasets in CDP Data Visualization.

Data preview area

The data preview area has two tabs: Datasets and Connection Explorer.

In the Datasets view, you can see all existing datasets on a connection available for creating visuals.
In the Connection Explorer view, you can manage functions related to the data on a connection. You can check the databases and preview table details in the data connection.
  1. The database area shows all databases that you can access through the current connection. Selecting a database displays its tables.

  2. The Datasets column lists the number of datasets that use the particular table as their initial definition.

  3. You can click the New dataset link to create a dataset on a specific table.

  4. To see more information about data tables, you can click the row of each table. The additional information is displayed under two tabs: Sample Data and Datasets.