Creating Relationships Between Live Tables

Relationships specify the connection between tables, and enable you to pull data together in meaningful ways.

For example, order information is more useful when you know which customer placed each order. However, you do not need to store both the customer and order information in the same table. Customer and order data can be stored in two related tables with a relationship specified between the two tables to view each order and its corresponding customer information.

In practical terms, relationships allow you to query and combine data from multiple tables in your dashboard.

If you have deployed Sisense on Linux, you can connect tables from multiple schemas for any of the following data sources:

  • Amazon Redshift
  • MsSQL
  • PostgreSQL
  • Snowflake

When you connect to a data source, such as Amazon Redshift, which has multiple schemas, you can select tables from each schema in the Add Data Wizard so long as the tables are not the same. When you add these to your model, each table displays as a single node that can be joined to other nodes.

Note:

Sisense recommends creating relationships between tables on high-performance databases. If enabling this for other databases, Sisense recommends testing the dashboard performance to ensure that it is not impacted before publishing the dashboard to your users.


To manually create a relationship between tables:

  1. Drag a table with the relevant field onto another table with the relevant field.

    The Relationship preview window is displayed.

  2. Click the columns to be joined from each table. Ensure both fields that you are using to create the relationship are of the same type, for example decimal fields.

    See the video below for a quick example.

  3. To check or change the field type, in the left pane, click the field type of the field you want to change and select the new type from the list of possible types displayed below it.

  4. Click Save to join the tables.

Note: When joining tables, the default join type is always an inner join. To achieve another join type, you must create a custom table.

To delete an existing relationship:

  1. Click on any part of the existing relationship. The Delete icon is displayed.

  2. Click
    to delete the relationship.