Cloudera Docs

Creating a dataset from a Direct Access query

After getting the results of a SQL query in the Direct Access interface, you can use the results as a basis of a new dataset.

  1. Click SAVE AS DATASET under the Query field.
  2. In the Create New Dataset modal, provide the required information.
    1. Under Dataset Title, enter the name of the new dataset.
    2. Under Dataset Source, retain the From SQL option. Alternatively, you can choose to create the dataset From Table.
    3. You can change the statement in the SQL text window.
  3. Click Create.

    You can now see the new dataset on the Datasets tab.