Amazon QuickSight
User Guide

Deleting a Data Set

Important

Currently, deleting a data set is irreversible and can cause irreversible loss of work. Deletes don't cascade to delete dependent objects. Instead, dependent objects stop working, even if you replace the deleted data set with an identical data set.

Before you delete a data set, we strongly recommend that you first point each dependent analysis or dashboard to a new data set.

Currently, when you delete a data set while dependent visuals still exist, the analyses and dashboards that contain those visuals have no way to assimilate new metadata. They remain visible, but they can't function. They can't be repaired by adding an identical data set.

This is because data sets include metadata that is integral to the analyses and dashboards that depend on that data set. This metadata is uniquely generated for each data set. Although the Amazon QuickSight engine can read the metadata, it isn't readable by humans (for example, it doesn't contain field names). So, an exact replica of the data set has different metadata. Each data set's metadata is unique, even for multiple data sets that share the same name and the same fields.

Use the following procedure to delete a data set.

  1. Before you begin, make sure that the data set isn't being used by any analysis or dashboard that someone wants to keep using.

    On the Your Data Sets page, choose the data set that you no longer need. Then choose Delete Data Set.

  2. If you receive a warning if this data set is in use, track down all dependent analyses and dashboards and point them at a different data set. If this isn't feasible, try one or more of these best practices instead of deleting it:

    • Rename the data set, so that the data set is clearly deprecated.

    • Filter the data, so that the data set has no rows.

    • Remove everyone else's access to the data set.

    It is a good practice to use whatever means you can to inform owners of dependent objects that this data set is being deprecated. Also, make sure that you provide sufficient time for them to take action.

  3. After you make sure that there are no dependent objects that will stop functioning after the data set is deleted, choose the data set and choose Delete Data Set. Confirm your choice, or choose Cancel.

Important

Currently, deleting a data set is irreversible and can cause irreversible loss of work. Deletes don't cascade to delete dependent objects. Instead, dependent objects stop working, even if you replace the deleted data set with an identical data set.