Materialized Views v1 (Deprecated)

Materialized Views v1 is deprecated in the next version of Mach5. Use the SQL-defined Materialized Views feature for new materialized views.

Go to the current Materialized Views documentation:

Materialized Views

What changed

Materialized Views v1 used an MQL view function and manual target mapping workflow. The current materialized views feature uses a SQL query definition, a refresh warehouse, a queryable target index, and SQL refresh commands such as:

REFRESH MATERIALIZED VIEW mv_name;
REFRESH MATERIALIZED VIEW mv_name FULL;
REFRESH MATERIALIZED VIEW mv_name INCREMENTAL;

Recommendation

For new work:

1. Create a SQL-defined materialized view.
2. Configure a refresh warehouse.
3. Provide a target mapping for production views.
4. Query the materialized target index from dashboards, SQL clients, or OpenSearch-compatible clients.

Existing v1 materialized views should be migrated to SQL-defined materialized views before relying on the next-version materialized view workflow.