Cloudera Docs

Cloudera Data Visualization, Data interface

The information and functionalities available on the DATA interface of Cloudera 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

If you have Manage data connections privilege or if you are an administrator:

  1. The NEW CONNECTION button is for connecting to a new data source. For more information, see Creating a new data connection.

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

  3. You can synchronise your Cloudera AI or Cloudera Data Warehouse connections. This action may overwrite any local changes. For more information, see Synchronizing data connections.

  4. samples is a SQLite connection in Cloudera Data Visualization that contains example datasets. This connection is read-only by design, so sample datasets cannot be modified.

  5. You can edit the details of a data connection using the icon. For more information, see Editing basic data connection details.

If you do not have Manage data connections privilege, you can see the list of available connections and can explore the connection details by clicking the icon.

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