Cloudera Docs

Creating a data extract

Learn how you can extract data from a dataset to a table in the same or a different data connection.

  • You need to enable the data extract feature in Site Settings > Data > Enable Data Extracts. For more information, see Managing data related site settings.

  • You need the following privileges to work with data extracts:
    • Manage dataset right for the source dataset
    • Manage AVs/extracts right for source and target data connections.

Follow these steps to create a data extract:

  1. Click DATA on the main navigation bar.
    The Data view opens, displaying the Datasets tab.
  2. In the left navigation panel, select the connection on which your source dataset is defined.
  3. Select the dataset you want to use as a source for the data extract.
  4. Click Data Extracts in the left navigation panel.
    In the Data Extracts view, you can create data extracts and manage extracts that exist from this dataset.
  5. Click CREATE DATA EXTRACT.

    The CREATE DATA EXTRACT modal window opens.

  6. Select the frequency for the Data Extract refreshes.
    The default is Manual, but you can create custom schedules. For more information, see Creating new schedules.
  7. Select the data connection where the Data Extract will be stored.
    It can be the same connection where the source dataset is or you can also choose a different connection.
  8. Select the database on the previously selected connection where you want to store the Data Extract.
  9. Enter a target table name, starting with cdv_.
  10. Select the dimension and measure fields depending on what data you want to store in your extract.
    If you want to use the selected measures as they are and you do not want the columns to be aggregated, deselect the Use aggregate functions below option.

    When configuring a data extract, you can search for a column by name, as well as view the field types and complex data types available.

  11. Optional: If you want to send an email confirmation about the extract's status, switch to the Advanced tab of the Create Data Extract modal window.
    1. Select what event(s) you want to be notified about - success, failure or both.
    2. Add one or more email addresses as recipients.
    3. You can edit the default subject line of the notification email.
  12. Click CREATE DATA EXTRACT after all required fields are completed.
    When the extract is created, you can refresh it manually or it will be refreshed on the schedule you defined in Step 5.

The extract is created, and its state shows as Never run.

You must run the extract to populate the target table and allow building a dataset or dashboard on the target table.