Whenever you delete a data source, you also have the option to drop or retain the table it loads into in the target system (ThoughtSpot). This is useful when you make changes to a table and create a new data source that loads into the table. So, you can safely delete any data source that references a target table that you don’t want to lose.
Before you begin, if there are any recurring data load jobs for the data source you are deleting, follow the steps in Stop a scheduled job from running. Then, do the following to delete a data source:
- Log in to ThoughtSpot from a browser.
Click on DATA, on the top navigation bar.
Click the Data Sources tab at the top of the screen.
- Find the data source you want to delete, and click on its name.
- Click Edit. This will bring you to the setup screens for a new data source. Step through all the screens by clicking Next, until you reach the final page.
- Click the Import button.
Click the here link to review the TQL script that created the target table in ThoughtSpot.
- Take a look at the table name and its schema. Decide if the table is one you want to keep in ThoughtSpot.
Go back to the data sources listing, click the checkbox next to the data source, and delete it.
In the Confirm delete prompt, select the checkbox if you want to delete the tables associated with the data source. Leave the checkbox unselected if you have decided to keep the tables.