Back to Presto

REFRESH MATERIALIZED VIEW

presto-docs/src/main/sphinx/sql/refresh-materialized-view.rst

0.297780 B
Original Source

========================= REFRESH MATERIALIZED VIEW

.. warning::

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

To enable, set :ref:`admin/properties:\`\`experimental.legacy-materialized-views\`\`` = ``false``
in configuration properties.

Synopsis

.. code-block:: none

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

:doc:create-materialized-view, :doc:drop-materialized-view, :doc:show-create-materialized-view, :doc:/admin/materialized-views