Cloudera Docs

Creating a dataset

Cloudera Data Visualization allows you to create datasets based on your data available through a data connection.

There are two options to create a new dataset:

Creating a dataset from a table

Cloudera Data Visualization allows you to define a new dataset based on an exisiting table.

  1. On the main navigation bar, click DATA.
    The Data view opens, displaying the Datasets tab.
  2. Click NEW DATASET near the top of the screen.

    The New Dataset modal window opens.

  3. In the New Dataset modal window, specify the following values:
    Dataset title

    Provide a name for the new dataset.

    Dataset Source

    Open the menu and select the From Table option.

    Select Database

    Scroll down the list of connected databases to select the correct database.

    Select Table

    Scroll down the list of tables to select the correct table.

  4. Click CREATE.
    You can now see the new dataset on the Datasets tab.

Creating a dataset from a query

Cloudera Data Visualization allows you to define a new dataset using a SQL query. This feature makes it easy to restrict access to specific table columns or rows for all users, either for security or for relevancy reasons. It also enables you to specify complex joins and analytic functions at the dataset level.

Using the DATA tab

  1. On the main navigation bar, click DATA.
    The Data view opens, displaying the Datasets tab.
  2. Click NEW DATASET near the top of the screen.

    The New Dataset modal window opens.

  3. In the New Dataset modal window, specify the following values:
    Dataset title

    Provide a name for the new dataset.

    Dataset Source
    Open the menu and select the From SQL option.
    Enter SQL below
    1. Enter the SQL query you want to use to define the new dataset.
    2. Run the query.
  4. Click CREATE.
    You can now see the new dataset on the Datasets tab.

Using the SQL tab

  1. On the main navigation bar, click SQL.
    The SQL view opens.
  2. Select the database and the table.
  3. Add the SQL query to the SQL text field.
  4. Click RUN.
  5. Click SAVE AS DATASET.
    The New Dataset modal window opens.
  6. Add a title for the dataset.
  7. Click CREATE.
    You can now see the new dataset on the Datasets tab.