Dataset Links

Introduction to Links

Links create a pre-defined join pathway between two data sources. Once a Link is defined, users will easily be able to add columns from the linked data sources to workbooks based on the dataset. Data relationships that already exist in your database are pulled into Sigma. If you have foreign keys set up in your warehouse, you should automatically see those relationships in the Links tab. 

Data added in via Links is always added via a Left Join. Links only support Many-to-One or One-to-One relationships. Each row in your source object should have at most one possible result in your target object or wrong results will be introduced into workbooks that use the link.

The power of Sigma’s links is that you can do more than create links between tables. You can create a link between any two data sources in Sigma. You can create a dataset that defines Metrics, then link it to a warehouse table so that users can pull in additional customer information. You can create a link between two datasets, two warehouse tables, or any other combination. Links allow you to create pathways of exploration, without limiting your users.

Plus, Sigma preserves the work you’ve already done to set up relationships between your database tables.

Create Links

1. Use the left-hand navigation menu to navigate to the dataset or table you would like to create a Link for.
2. Open to the Links tab.
3. Click the Edit button in the top right.
4. Click Add Link to other sources.
   
5. Use the left-hand menu to choose the data source you would like to connect to. Ensure that your source data has a one-to-one or many-to-one relationship with the target data. 
6. Once you select the data source, a preview will appear.
7. Click Next in the page header. 
8. Preview your join column and the join results on the right hand side of the screen.
9. Click Accept in the page header.
10. You will now see your new Link listed on the Links tab.
11. Click Publish to save and publish your new Link.