Delete a relationship

You must have either the Can administer ThoughtSpot or the Can manage data privilege to delete a relationship. If you’re not an administrator, you also need edit permissions on the table, view, or worksheet.

If you created a relationship (join or link) between tables using the web interface, you can also delete it from the web interface. But if the relationship was created using TQL, you must also use TQL to delete it.

To delete a relationship using TQL, use an ALTER TABLE...DROP CONSTRAINT... or ALTER TABLE...DROP RELATIONSHIP... statement.

To delete a relationship from the web interface:

  1. Select Data on the top navigation bar.

  2. Select the name of the data source you from which you want to remove the relationship.

  3. Select Joins.

    The list of existing joins appears.

    In a worksheet, you must select Joins within this worksheet and choose Joins from this worksheet.

  4. Find the relationship you want to delete, and select the delete icon. The Confirm delete window appears.

    If the join has dependents, a different window appears, warning you that deleting this join makes the dependent objects stop working until you recreate the join later. However, ThoughtSpot doesn’t delete the dependent objects. You can use this functionality to reverse the join cardinality or otherwise edit a join without deleting its dependents.

  5. Repeat these steps until all the joins you want to remove have been deleted.


Related information