REFRESH MATERIALIZED VIEW

Warning

Materialized views are experimental. The SPI and behavior may change in future releases.

To enable, set experimental.legacy-materialized-views = false in configuration properties.

Synopsis

REFRESH MATERIALIZED VIEW view_name

Description

Refresh the data stored in a materialized view by re-executing the view query against the base tables.

Examples

Refresh a materialized view:

REFRESH MATERIALIZED VIEW daily_sales

See Also

CREATE MATERIALIZED VIEW, DROP MATERIALIZED VIEW, SHOW CREATE MATERIALIZED VIEW, Materialized Views