Create joins between your tables to

With joins, you can make a single search retrieve rich data and dimensional information across multiple tables of your database.

If your database uses any table joins, they appear in ThoughtSpot.

About joins


Select origin table

Select tables

  1. Select the connection:

    • On the top bar, click Data.
    • Click Connections.
    • Select and click on your connection.
  2. The Connection details include the listing of all tables in the connection.

  3. Select the fact table, so the join direction points from many to one. This is important.

  4. In the table detail view, select the Schema option.

  5. If your connection already has joins between tables, they appear in the Schema and Joins interface.

  6. To specify a new join, click + Add join.

Create the join

Create the join

  1. After you click + Add join, the Add join interface appears.

  2. The Source Table of the join is set.

  3. Select the Destination Table. This is usually a dimension table.

  4. Under the Source Table, select the Source Column that connects the two tables.

  5. The Destination Table, select the Destination Column that matches the Source Column. Note that the match is for the data; it does not matter if the columns have the same name.

  6. Click Next.

  7. Specify the Join Name, and optionally, the Join Description.

  8. Click Next.

You can now see the updated view of the Schema. The direction of the join is from the fact table to the dimension table.

You can also see the detailed information about all Joins. Note that you can change the name and description of the joins, and you can delete these joins. However, you cannot change their type, or their direction direction.

Proceed to create all necessary table joins, to support your data requirements.

Congratulations! Your search can now pull data from all joined tables.

Next steps

Next, create Worksheets.

Additional resources

As you develop your expertise with joins and schema, we recommend the following ThoughtSpot U course:

See other training resources at
ThoughtSpot U