Documentation

Using Calculations
-
Integrations
-

Data Blocks

Sigma’s Data Blocks are a flexible way to build centralized data definitions and guide data exploration. Sigma balances administrative control with the freedom to find, add, and trust new data. There are three types of Data Blocks in Sigma: Table Blocks, Worksheet Blocks, and SQL Blocks.

Specific kinds of data blocks have different functionality. However, all Data Blocks function as sources of data.

One of the most powerful features of Data Blocks are Links. You can define the relationships between Data Blocks on the Relationships tab, setting up the join keys between the Data Blocks. Once a Relationship is defined, all worksheets created from that Data Block will have a Linked Column, which allows users to add columns from a different Data Block, using the join defined in the Relationship.

Types of Data Blocks

Table Blocks

  • All Table Blocks can be found in the ‘Connections’ section of the left-hand navigation menu
  • Automatically created from tables and views in the database
  • Descriptions and foreign keys set in the database are pulled into Sigma
  • Edit descriptions and relationship from within Sigma

SQL Blocks

  • Use SQL to define the data within the Data Block
  • Materialize the results of your SQL back to the data warehouse as a table. This helps speed up query time and reduces compute.
  • Create Relationships and Descriptions within Sigma

Worksheet Blocks

  • Turns a Sigma Worksheet into a Data Block. This designates the block as a data source for users, sets up calculatations as a Single Source of Truth, and allows users to materialize the data in the Worksheet.
  • Materialize the results of your Worksheet back to the data warehouse as a table. This helps speed up query time and reduces compute.
  • Create Relationships and Descriptions within Sigma

Add a Description

  1. Navigate to the overview page.
  2. Click ‘Edit’.
  3. Click to add a description.
  4. Hit ‘Publish’ to save the changes.


Format Columns

  1. Navigate to the overview page.
  2. Click ‘Edit’.
  3. Find the column that you would like to format, and click the arrow next to the column name to open the column menu.
  4. Choose the formatting option that you would like to apply.
  5. Hit ‘Publish’ to save the changes.


Add Column Descriptions

  1. Navigate to the overview page.
  2. Click ‘Edit’.
  3. Click ‘Columns’ to go to the column page.
  4. Click to add a description.
  5. Hit ‘Publish’ to save the changes.


Add a Badge

  1. Navigate to the overview page.
  2. Click the flag icon next to the name of the table.
  3. Choose which badge you would like to apply.
  4. If you would like to, you can add a note about the badge you are adding.
  5. Click add.