Using Materialized Views

Materialized views cache the results of a query and can speed up query processing, especially when replicating a query with heavily aggregated data. Once the query results are cached, materialized views must be manually updated and the manual query updates make take as long to perform as the original query.

Materialized view data is stored internally in either query engine memory or in dedicated external data connector storage. When it is initially loaded, it is stored in query engine memory and no target source ID (targetSourceId) or field mappings (targetFieldMappings) are provided. However, when the materialized view is recalled, its data is stored in external data connector storage and both the targetSourceId and targetFieldMappings are provided. You can use the targetSourceId in some of the following cURL commands for the /api/materialized-views endpoint.

Support for materialized views is performed using the REST API endpoint /api/materialized-views, as described below.

For complete information about Zoomdata's API, see Composer REST API Overview.