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: Records the timestamp and user email address associated with each row's creation or most recent update.
  • Row ID: Populates unique row 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 options, see Configure data governance options for input tables.

Add row edit history

🚩

This documentation describes a public beta feature and is under construction. This page should not be considered part of our published documentation until this notice, and the corresponding Beta flag on the feature in the Sigma service, are removed. As with any beta feature, the feature discussed below is subject to quick, iterative changes. The latest experience in the Sigma service might differ from the contents of this document.

Beta features are subject to the Beta features disclaimer.

Add columns containing row edit history to provide data transparency and promote accountability. Row edit history columns track the timestamp and user email associated with row edits that occur through direct input and actions.

  • Click the plus () icon at the end of the column header, then hover over Row edit history and select an option:

    Last updated atDate and time the most recent edit was applied to the row.
    Last updated byEmail address of the user who applied the most recent edit to the row.
    Created at (Beta)Date and time the row was added to the input table.
    Created by (Beta)Email address of the user who initially added the row to the input table.

    The column populates the edit history for all existing rows in the input table.

    📘

    When a user duplicates an input table, all row edit history (Created at/by and Last updated at/by) in the copy initially reflects the time of the duplication and the user who initiated 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 irrelevant to linked input tables and only available for empty and CSV input tables.

  • 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.

    📘

    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.