Use Materialized Views (Experimental)

This applies to: Visual Data Discovery

The Materialized Views API is deprecated. This API will be removed in a future release.

Materialized view functionality is disabled by default. To enable, contact technical support for assistance.

Materialized views allow you to use pre-aggregated query results to speed up query processing in certain scenarios, especially when processing a query with heavily aggregated data. This boosts your visual rendering time.

This is an experimental feature.

Materialized views only work if the metrics and groups in the materialized view definitions match those used by your visuals. For example, no benefit from using materialized views will occur if you define a materialized view for the Planned Sales metric in a data source, but none of the visuals in your environment use the Planned Sales metric. Consequently, it is a good idea to understand what data in your data source is used (or will be used) in visuals before you define a materialized view.

A Count metric is required in all materialized view definitions.

Support for materialized views is performed using the REST API endpoint /api/materialized-views, described in Materialized Views API (Experimental). You can also specify materialized view settings for a data source configuration using the UI. See the following topics:

• List Materialized View Definitions
• Add a Materialized View Definition
• Edit a Materialized View Definition
• Delete a Materialized View Definition
• Enable and Disable Materialized View Definitions