Configure data governance options in input tables

🚩

Input tables are currently supported by Snowflake and Databricks connections only.

Sigma allows you to preserve data integrity and enhance security in input tables by adding data validation, protecting columns, and customizing data entry permissions. You can also display user and timestamp metadata for auditing purposes when multiple users contribute to input table updates.

This document explains how to implement data validation, column protection, data entry permissions, and row edit history in empty, CSV, and linked input tables.

System and user requirements

The ability to configure data governance options in input tables requires the following:

  • You must be granted Can use data permission for a Snowflake or Databricks connection with write access enabled. If using an OAuth-enabled Snowflake connection, see Configure OAuth with write access for additional requirements.

  • You must be assigned an account type with the Create input tables and Create, edit, and publish workbooks permissions enabled.

  • You must be the workbook owner or be granted Can edit workbook permission.

Apply data validation

Apply data validation to individual columns to ensure data accuracy and consistency. Data validation verifies existing values and restricts new inputs to predefined values.

📘

Sigma only supports data validation for text, number, and date columns. Data validation doesn’t apply to checkbox data columns because Sigma already restricts the values to true (selected) or false (cleared).

  1. Click the caret () in a column header to open the column menu, then select Data validation.

  2. In the Data Validation modal, create a manual list of predefined values, or apply the values from a column in an existing data source or element in the workbook:

    • Create a manual list of values:

      1. In the Value source dropdown, select Create manual list.

      2. In the Define values field, enter values that align with the column’s data type.

        💡

        Enter individual values, or paste multiple values copied from Sigma or an external source (like a spreadsheet or text document).

      3. Click Save.

    • Apply values from a column in an existing data source or element:

      1. In the Value source dropdown, select a data source or element.

      2. In the secondary dropdown, select a source column to define the values.

      3. Review the column values, then click Save to proceed.

      Sigma checks existing data against the defined values and displays red indicators in cells that contain invalid data.

  3. To replace invalid data, manually enter valid values, or click the caret () in the cell and select a predefined value from the dropdown.

Add/remove column protection

Protect individual columns to prevent edits, like adding data validation, changing the column type, or deleting the column. You cannot insert or delete rows in an input table when column protection is applied to one or more of its columns.

  • To add column protection, click the caret () in a column header to open the column menu, then select Protect column.

  • To remove column protection (indicated by a lock icon () in the column header), return to the column menu and select Unprotect column.

Set data entry permission

Set the data entry permission to determine which workbook version (draft or published) allows users to add rows or edit table values.

The ability to create and configure input tables remains limited to the workbook’s draft version (Edit mode). By default, data entry is also restricted to the draft, meaning only users granted Can edit workbook permission can enter and edit input table data. However, Sigma allows you to extend this functionality to users granted Can explore workbook permission by enabling data entry in the workbook’s published version (View and Explore mode).

For information about the data entry workflow in a workbook draft versus a published version, see Edit existing input table columns.

  1. In the element toolbar, click More to open the element menu, then select Set data-entry permission.

  2. In the Set data-entry permission modal, select a permission option, then click Save. You can toggle data entry between the draft and published versions as needed, but they cannot support data entry simultaneously.

    Only in Draft versionAllows users to edit input table data in Edit mode if they’re granted Can edit workbook permission.
    Only on Published versionAllows users to edit input table data in View and Explore mode if they’re granted Can explore or Can edit workbook permission.

    🚧

    Data entry permission updates aren't applied to the input table until the workbook is published.

Add row edit history

Add row edit history to provide transparency and promote accountability by timestamping edits and identifying users responsible for the changes.

  • Click the caret () in a column header, then hover over Add new column and select a Row Edit History option:

    Last updated byIdentifies the user responsible for the latest row-level edit.
    Last updated atRecords the date and time the row was last edited.