post https://api.sigmacomputing.com/v2/dataModels/:materialize
This endpoint runs a scheduled materialization for an element in a data model. Materialization processes the data of the specified element, allowing the data to be stored or cached for optimized access and performance.
For more details on materialization, see Materialization.
Usage notes
- The materialization schedule for the specified element must be created beforehand.
- Retrieve the sheetId by calling the /v2/dataModels/{dataModelId}/materialization-schedules endpoint.
- Retrieve the dataModelId by calling the /v2/dataModels endpoint.
Usage scenarios
- Performance optimization: Use this endpoint to improve response times for frequently accessed data model elements.
- Data refresh: Allows users to manually (programmatically) refresh the data of specific data model elements to ensure that the latest data is available for analysis and reporting.
Best practices
- Prioritize materialization for elements that are heavily used or form critical components of business reports.
- Monitor the performance impacts of materialization and adjust strategies as necessary to optimize resource usage and response times.