Materialization lets you write Datasets back to your data warehouse as a table. The Datasets will be written to a table in your data warehouse on the schedule that you set. The table in the warehouse will be replaced each time the materialization schedule runs.
Set Up Materialization
Only Admins can set up Materialization schedules.
- Set up Write Access.
- Go to the overview page of the Dataset you would like to materialize. SQL based Datasets and Worksheet based Datasets both have the option to materialize.
- Click the ‘Edit’ button in the upper right.
- Go to the Materialization Tab.
- Click ‘Create Schedule’.
- Set the schedule for when you would like your Dataset to materialize.
Which Datasets Can Be Materialized
All SQL based Datasets can be materialized.
Only worksheet based Datasets that exclusively use Tables, inline SQL, and CSV uploads as sources will have materialization available.
If parameters or system functions are used in the Dataset, materialization will not be available.
Materialization queries can run for up to 24 hours before being cancelled. Long running queries that do not display in Sigma can still be materialized.
Materialized Tables in Your Warehouse
Materialized tables exist in the schema designated when you set up Write Access. They are visible through your cloud data warehouse but are not intended to be used as source tables for other applications. They also will not show up in Sigma through the connection browser.
If changes are made to materialized tables in the database, it will result in unexpected behavior, results or query failures.
Deleting Materialized Tables
When a materialization schedule is deleted completely, Sigma will automatically remove the materialized table from the warehouse. It can take up to 24 hours for the table to be deleted.