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.
cURL Command | Description |
---|---|
GET /api/materialized-views | Returns a list of all materialized view mappings. |
POST /api/materialized-views | Creates a new materialized view mapping. |
PUT /api/materialized-views/{ID} | Updates a specific materialized view mapping. |
PATCH /api/materialized-views/{ID} | Patches (partially updates) a specific materialized view mapping. |
DELETE /api/materialized-views/{ID} | Deletes a specific materialized view mapping. |
For complete information about Zoomdata's API, see Composer REST API Overview.
Comments
0 comments
Please sign in to leave a comment.