🚩

This documentation describes a public beta feature and is under construction. This documentation 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.

If you have a data model with one or more tagged versions, you can set up materialization schedules for each version of the data model.

For example, if you have “testing” and “production” tags set up for a data model, you can configure materialization for the data elements in both tags, which can improve the performance of downstream elements.

When scheduling materialization of elements in version-tagged data models, the best practices for materialization still apply.

Requirements

• To use this feature, you must be assigned an account type with the permission to materialize data.
• To materialize a data element, the connection for the data source must have write-back enabled.

Schedule materialization for a tagged data model

For a data model with at least one tagged version, schedule materialization for one or more data elements. To materialize a data element, the connection for the data source must have write-back enabled.

1. Open the data model.

2. Open the materialization modal. In the document header, next to the refresh data button, click More options.

3. In the Materialization modal, click + New schedule.

   💡

   To duplicate an existing schedule instead, locate the schedule that you want to duplicate and select More > Duplicate schedule.

4. For Version, select to modify the version, then in the dropdown, select the version tag to which the schedule applies.

5. For Elements, add data elements to the schedule. To materialize elements in this tagged version that are materialized in the published version or another tagged version of the data model, select + Add element, then choose Copy elements from schedule of other versions.

6. Set the frequency of the schedule:

   • (Optional) Select the dropdown for Daily and select Weekly, Monthly, or Custom.

     • For Daily, select Once a day or Multiple times.

     • For Weekly, select which days of the week to run a materialization job, and choose between Once a day or Multiple times.

     • For Monthly, select which day of the month to run a materialization job, and the time of day.

     • For Custom, specify a schedule using cron syntax. See Set up a custom delivery schedule.

       If you select Multiple times, specify the frequency. For example, every 2 hours on the :15 of the hour between 9 AM and 6 PM.

   • (Optional) Adjust the default schedule time zone using the dropdown menu.

7. Save the schedule.

📘

Different version tags cannot share the same schedule. If you want to materialize data elements in both tag A and tag B, you must create two schedules.

Usage Notes

• When you update a tag with a materialization schedule from one version of the data model to another, a new materialization run is started. This is similar to how publishing an element with materialization will trigger a new materialization to be built.