View input table audit history

Input table audit history records versioned snapshots of input table row and schema changes over time. For each input table, Sigma automatically creates a warehouse-native view in your data platform that can help you understand the following:

• Row-level history: What changed in a specific row, who made the change, and when the change occurred.
• Schema history: When a column was created or changed to a different data type, along with who made the change and when the change occurred.

This document explains how to view the audit history for a specific input table.

Requirements

There are two ways to access the audit history for a specific input table: Query the view using custom SQL, or create a table element that references the audit history view. The requirements for each method are as follows:

• The ability to query the view using custom SQL requires the following:

  • You must be assigned an account type with the Create, edit, and publish workbooks and Write SQL permissions enabled.
  • You must have Can use access to the connection the input table writes to.
  • You must be the workbook owner or be granted Can explore or Can edit workbook access.

• To surface the audit history as a table element, you must be assigned the Admin account type.

Considerations

• Audit history does not capture changes to column names. Renaming a column in Sigma updates the column’s display name in the workbook, but it does not modify row-level data or the underlying warehouse schema.
• When an admin edits an input table while impersonating a user, the audit history attributes the edit to the impersonated user, not to the admin who performed it. Impersonation itself is recorded in your organization’s audit log, which identifies both the impersonated user and the impersonating admin. For more information, see Impersonate users and Access and explore audit logs.

Query audit history using custom SQL

Use custom SQL to query the audit history for a specific input table in an existing workbook. You can also create a new workbook from a SQL query and skip to step 4. See Create a workbook from SQL.

1. Open a workbook draft or custom view. The workbook doesn’t need to contain the relevant input table.

2. In the Add element bar, select Data > Table.

3. In the Select source popover, select SQL as the data source, then choose the same connection the input table uses.

   You can confirm the connection the input table uses in the workbook lineage. In the input table’s element toolbar, click More, then select View lineage and reference the Connection field in the element’s summary card.

4. Sigma adds a new SQL element to the workbook. In the query editor, enter the following SQL statement, replacing <DATABASE>, <SCHEMA>, and <INPUT_TABLE_ID> with the relevant values for your input table.

   1
   SELECT * FROM <DATABASE>.<SCHEMA>."INPUT_TABLE_AUDIT_LOG_<INPUT_TABLE_ID>"
   You can obtain the database, schema, and input table ID values from the query history in the workbook containing the input table (see View individual query details for guidance on access). In the query history, select any query that references the input table, then find the database table name (structured as <DATABASE>.<SCHEMA>.<INPUT_TABLE_ID>) in the SQL. When parsing the input table ID for the SQL statement, exclude the SIGDS_ prefix.

5. Click Run, then view the audit history in the SQL result or Table tab.

Create a table element containing audit history

If you’re an organization admin, you can create a table element that surfaces the audit history view for a specific input table. When the table element is published, it’s available to any user who has access to the workbook and the ability to view the page containing the table.

1. Open the draft of the workbook containing the relevant input table.

2. In the input table’s element toolbar, click More, then select Advanced options > Create audit history table.

   Sigma adds a new table element containing the input table’s audit history.

3. In the workbook header, click Publish to make the table available to all users who can view the workbook page containing the table.