Add system-generated columns to input tables

Add system-generated columns to input tables to expose metadata for auditing and other data management processes.

• Row edit history: Generates a timestamp for the most recent edit (Last updated at) in each row and identifies the user responsible for the change (Last updated by).
• Row ID: Generates unique identifiers that support data management and referential integrity.

This document explains how to add system-generated row edit history and row ID columns to input tables. For information about other input table data governance features, see Apply data validation to input table columns and Configure data entry and editing rules on input tables.

Add row edit history

Add columns containing row edit history to provide data transparency and promote accountability.

• Click the plus (+) icon at the end of the column header, then select one of the following Row edit history options from the dropdown:

  Last updated at	Records the date and time the row was last edited.
  Last updated by	Identifies the user responsible for the latest row-level edit.

  The column populates the edit history for all existing rows in the input table. For empty rows, the column indicates when the row was added or the user who added it.

  

Add row ID

Add a column containing row IDs to establish a primary key that uniquely identifies each row in the input table.

📘

• System-generated row IDs are only available for empty and CSV input tables, as they are not relevant for linked input tables.

• When a user duplicates an input table, Sigma preserves the row IDs for existing rows, resulting in identical IDs in the original and copy. For new rows added after duplication, however, Sigma generates unique IDs.

• Click the plus (+) icon at the end of the column header, then select Row ID.

  The column populates a unique ID for all existing rows in the input table, including empty rows.