Review and manage your data catalog

For each data source connected to Sigma, you can review and manage the data catalog. Explore the databases or catalogs, schemas, and tables available in Sigma, and add descriptions and other metadata to tables and columns.

Table badges, descriptions, and column descriptions are available downstream, helping business users make decisions about which tables and columns to use in a given analysis.

To further model the data from your data platform, you can also create a data model or dataset in Sigma:

• Create a data model from a table.
• Create a dataset from a table.

System and user requirements

The ability to manage your data catalog in Sigma requires the following:

• Your organization must be connected to a data source.
• You must be assigned an account type with the Manage connections permission enabled.
• You must be granted Can use & annotate access to the connection.

Annotate tables with metadata

Add metadata to data catalog tables in Sigma, such as table descriptions, a badge to indicate certification status, column descriptions and data types, and configure additional column settings.

Table and column descriptions are visible to business users interacting with the data table, either by hovering over a given column in a workbook or when viewing the lineage of a data model using the database table as a data source.

Find relevant tables

Start by locating the relevant tables that you want to annotate:

1. From Sigma Home, select Connections to open the list of connected data sources.
2. Select the data connection with the data catalog that you want to view.
3. In the left navigation panel, search or browse the data catalog to locate the table that you want to annotate.
   

Add table descriptions

After locating the table in your data catalog, add a description:

1. Navigate to the table in the data catalog.
2. Select the table name to open the table.
3. In the upper right, select Edit.
4. Next to the table name, select More info ().
5. In the popover that appears, enter a description in the Description field.
   
6. To save your changes, select Publish.

Add or update a badge

Add or update a certification badge to indicate the status, quality, and reliability of the data.

1. Navigate to the table in the data catalog.
2. Select the table name to open the table.
3. Next to the table name, select More info ().
4. In the popover, select an option from the Badge dropdown.
   
5. [optional] When you select a badge, the popover displays the Badge note field. Add a note to provide context about the badge.
   
   The badge is automatically saved and immediately reflected by the table icon in the left panel.

Add column descriptions

1. Navigate to the table in the data catalog.

2. Select the table name to open the table.

3. In the upper right, select Edit.

4. Select the Columns tab.

5. In the Description column, add a description for any column in the table.
   

6. To save your changes, select Publish.

Format columns

To change the format of data in a column, for example to display numeric data with currency formatting, format columns in the table:

1. Navigate to the table in the data catalog.
2. Select the table name to open the table.
3. In the upper right, select Edit.
4. Select the Columns tab.
5. Locate the column that you want to format.
6. For Format, choose the formatting option that you want to apply to the column. Formatting options depend on the data type of the column. For example, for a numeric column, select Currency.
7. To save your changes, select Publish.