Delete a data source

When you want to delete a data source, you first need to handle any dependent objects that have been built on top of it. You can easily see these dependencies, and choose how to handle them before deleting the data source.

Check data source dependencies

You can see all of the dependencies for any data source (worksheet or table) on the Data page.

To view dependent objects for a data source:

  1. Select Data on the top navigation bar.

  2. Select the name of the data source whose dependencies you want to view.

  3. Select Dependents.

    You will see a list of the names of the dependent objects (worksheets and Liveboards), and the columns they use from that data source. You can use this information to determine the impact of changing the structure of the data source or to see how widely it is used.

    List of dependents for the Sporting Goods Retail Worksheet
  4. Select a dependent object to modify or delete it.

    If you want to remove the dependency by modifying the dependent object, you must remove all search terms or columns that refer back to the data source you are trying to delete.

  5. When all dependencies have been removed, you will be able to go back and delete the data source.

Delete a data source

You can delete data sources from the browser, as long as they were not created by an administrator through tsload.

You can delete data sources from the browser if they were created in the browser. These types of data sources include:

  • Data imported from the browser.

  • Worksheets.

ThoughtSpot checks for dependencies whenever you try to delete a table or worksheet.

  1. Select Data on the top navigation bar.

  2. Check the box next to the name of the data source you want to delete.

  3. Select the delete icon.

  4. If you attempt to delete a data source with dependent objects, the operation will be blocked.

    You will see a list of dependent objects with links.

    Cannot delete warning with a list of dependent objects
  5. Select a dependent object to modify or delete it.

    If you want to remove the dependency by modifying the dependent object, you must remove all search terms or columns that refer back to the data source you are trying to delete.

  6. When all dependencies have been removed, you will be able to go back and delete the data source.