Cloudera Docs

Saving a table as a dataset based on the query

CDP Data Visualization enables you to save a query result as its own dataset. This is helpful when working with subsets of data, sections, or building datasets with self-joins.

When saving a query result as a dataset, follow these steps:

  1. Place the necessary fields on the shelves, and apply functions, sort, order, alias, filters, and so on.
  2. In the Create a materialized table or logical view modal window, fill out these fields:
    1. Enter the Name of the new table. We are using SnP.
    2. Choose the Type: Dataset directly from query.
    3. Under Create in database, choose an existing database where to save the table.
    4. Create a new dataset... option is on; enter the Dataset name.
    5. Click Create.
    Figure 1. Creating a New Dataset from a Query
    creating a new dataset from a query
  3. A success confirmation modal appears, with a link to the new default visual on the new dataset.
    displaying the link to the default visual on the new dataset
  4. Click the link to open a new default visual on the new dataset, in Edit mode.
    viewing the default visual in Edit mode