Manage materializations
If you are the admin of an organization, you can manage and troubleshoot materialization activity. For more details about materialization, see About materialization.
Requirements
To manage and troubleshoot materializations, you must be assigned the Admin account type.
Review scheduled materializations for your organization
To see a list of all materializations scheduled in your Sigma organization, do the following:
-
Go to the Admin Portal.
-
In the left panel, click Materializations.
-
Review the listed data elements and documents:
- Search for a specific materialized element or dataset by element name, data model or workbook name, or dataset name.
- Review the status column, for example to verify if a specific materialization was successful.
- Filter the table, for example by status or document type.
- Sort the table columns in ascending or descending order, for example to review schedules in time order.
- Select an element or dataset name to open the document.
Pause scheduled materializations
By default, Sigma pauses scheduled materializations that have not been used for 60 days or if they fail to run five times in a row. Any owner of a scheduled materialization can also manually pause a materialization. If a materialization is paused, materialized data is not used.
As an admin, you can change the settings used to automatically pause unused materialization schedules:
-
Open the Administration portal.
-
In the left panel, select Materializations.
-
For Pause schedule, select the option that reflects your business requirements:
- Never: Select this option if you do not want to pause materializations for any reason.
- If materialization table is not used for… days: Specify a number of days after which to pause materializations that are not in use. The default setting is 60 days.
Changes take effect immediately.
To resume a paused materialization schedule, locate the paused materialization schedule in the table, then select More > Resume.
View materialization logs and statistics
You can review logs, utilization ratio, and other usage data for your organization’s materialization activity in the Materializations usage dashboard.
- Open the Administration portal.
- In the left panel, click Usage, then select the Materializations tab.
Review the usage statistics and logs for all of your organization’s materialization runs.
Troubleshoot failing materializations
Materialization can fail for a number of reasons. Depending on what is materialized, users might experience different data:
- If materialization for a dataset fails, the dataset continues to use the last successful materialization.
- If materialization for a data element in a workbook or data model fails, the element uses live data and does not use the last successful materialization.
To troubleshoot a failed materialization, open the Materializations tab of the Usage page. You can view the logs for each materialization run, including specific error messages for failed materialization runs in the Materialization logs table. See Materializations usage dashboard.
When troubleshooting a failed materialization, review the materialization limitations and review the lineage for the data element, including any dataset links if relevant.
Manage materialization schedules with frequency presets (Beta)
This documentation describes one or more public beta features that are in development. Beta features are subject to quick, iterative changes; therefore the current user experience in the Sigma service can differ from the information provided in this page.
This page should not be considered official published documentation until Sigma removes this notice and the beta flag on the corresponding feature(s) in the Sigma service. For the full beta feature disclaimer, see Beta features.
When managing materialization schedules for your organization, create frequency presets to recommend a frequency and time zone. A frequency preset is a named schedule. When a user schedules a materialization for a workbook, data model, or tagged version of a data model, the preset appears in the Frequency dropdown. The user can select Custom to set a different frequency.
To create, edit, or delete frequency presets, you must be assigned the Admin account type. To select a preset for a materialization, you must be assigned an account type with Schedule materializations permission.
Create a frequency preset
- Open the Administration portal.
- In the left panel, select Materializations.
- Select the Scheduling options tab.
- Click Create preset to open the Create frequency preset modal.
- For Frequency, configure how often you want the materialization to run.
- For Schedule time zone, select the time zone for the schedule.
- For Name, enter a unique name of 128 characters or fewer, or leave the field blank to use the default.
- Click Create.
When a user selects the preset, the materialization runs on that frequency and time zone. See Schedule materialization for a data model or workbook.
Edit a frequency preset
- Open the Administration portal.
- In the left panel, select Materializations, then select the Scheduling options tab.
- Locate the frequency preset, then select
More > Edit.
- Change the frequency, time zone, or name.
- Click Save changes.
Every materialization schedule that uses the preset follows the new frequency and time zone.
Delete a frequency preset
Deleting a frequency preset pauses every materialization schedule that uses it. Sigma stops using the materialized results for those schedules, including the result from the last successful run. Those elements query their data sources directly.
- Open the Administration portal.
- In the left panel, select Materializations, then select the Scheduling options tab.
- Locate the frequency preset, then select
More > Delete.
- In the Delete frequency preset modal, select Delete.
After you delete the preset, schedules that used it prompt the user to choose a new frequency. Sigma also emails the document owner and the materialization owner.

