Use Linked Columns in Workbooks

Summary of Content

What are Links?
Link Accessibility in Workbooks
Add Columns from a Link
      Links in Tables
      Links in Element Focus View Tables
Related Resources

What are Links?

Links are column-based relationships created between two data sources in Sigma. They allow you to access data from one data source based on a column it shares with another data source.

These relationships can be defined by organization admins or creators during their data modeling process and are only available if explicitly defined. 

Cloud Data Warehouse (CDW) Tables can be linked to other CDW tables. Datasets can be linked to other datasets. And CDW Tables can be linked to dataset. A data source can have links to multiple other data sources. 

Screen_Shot_2021-05-27_at_7.24.41_PM.png

Link Accessibility in Workbooks

Links can only be accessed in workbooks through data elements created directly from a data source containing a linked column. Child elements of a data element that inherited links from its CDW or dataset parent will not continue to inherit those links. 

This means that if you want to access linked columns from a data element, you should either (1) create that element from the original data source containing the link OR (2) add the columns you want to the parent element so they can be directly inherited by the child.

Add Columns from a Link

Links in Tables

Linked columns in tables can be identified by the light blue background on their cell values. To add linked columns to a table:

  1. Click on a cell in the linked column to open the link popup.
  2. Check the box beside any column(s) you wish to display in your table.Screen_Shot_2021-05-27_at_7.37.10_PM.png

Links in Visualizations and Pivot Tables

Linked columns in visualizations and pivot tables are only accessible when the element is expanded to focus mode. While in focus mode, you access links through the focus view table. Link in table elements, linked columns can be identified by the light blue background on their cell values. To add linked columns to a visualization or pivot table:

  1. Expand the element to its focus view.
  2. From the focus view table, click on a cell in the linked column to open the link popup.
  3. Check the box beside any column(s) you wish to display in your table.Screen_Shot_2021-05-27_at_7.48.32_PM.png

Related Resources

Intro to Data Elements
Create a Data Element