Skip to main content

 

ThoughtSpot

Link Tables Using Relationships

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

You can link tables by creating relationships between their columns. Linked tables can be searched together or combined into a worksheet for easy searching. Tables that have no relationship between their columns can not be combined in a single search.

There are two ways to create relationships between tables:
  1. Create a constraint using TQL.
  2. Create a relationship through the Web interface.

The two methods create the same kind of relationship from an end user perspective, but there are differences.

Relationships created through TQL exist within the database, and can be scripted. You can also generate a script through TQL that contains these relationships.

Relationships created through the Web interface can be managed by going to the Relationships page when viewing data in the Date Modeling section in the ThoughtSpot Web application. You can view, modify, or delete relationships there.

You may create relationships using a mixture of TQL and the Web interface, but the relationships you create cannot form a circular relationship, or "cycle". If you attempt to create a relationship that would complete a cycle, you will see a message saying that the relationship could not be added because it conflicts with another existing relationship.

  • Was this article helpful?