Cloudera Docs

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 and data extracts.

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 and extracts. The interface has the following main parts:
  1. DATA interface top menu bar
  2. DATA interface side menu
  3. DATA interface 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

  1. The NEW CONNECTION button is for connecting to a new data source.

  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 three tabs: Datasets, Connection Explorer, and Data Extracts.

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.

In the Data Extracts view, you can see all existing data extracts on a connection.

  1. Overall statistics

  2. List of Data Extracts sourced from the current data connection