Cloudera Docs

Editing a data extract

After creating a data extract, you can update its settings, schedule, target table, or selected fields.

  1. Click DATA on the main navigation bar.
    The Data view opens, displaying the Datasets tab by default.
  2. Click Data Extracts.
    The Data Extracts view is displayed, showing all data extracts defined in the Cloudera Data Visualization instance.
  3. Locate the data extract you want to edit and click the name of the source dataset and click the name of its source dataset.
    The Dataset Detail view is displayed.
  4. Click Data Extracts in the left navigation panel.
    The Dataset Detail view is displayed, showing the data extracts defined on the selected dataset.
  5. Locate the data extract you want to edit and click EDIT at the end of the extract row.
    The Edit Data Extract modal opens.
  6. Update any of the available fields as needed.
    • Refresh schedule
      You can modify the data extract’s refresh schedule.
    • Target data connection
      You can change the connection used by the extract.
    • Target database
      You can change the database used by the extract.
    • Target table name
      You can update the name of the table where the extract is stored.
    • Data from imension and measure columns
      You can add or remove fields included in the extract.
  7. Optional: If you want to send an email confirmation about the extract's status, switch to the Advanced tab of the Edit Data Extract modal.

    In the Advanced tab, you can:

    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. Edit the subject line of the notification email.
    4. Enable or disable query rewrites.
  8. Click Save to finalize your changes.