Refresh a materialized view
You can refresh a View manually, so that its data matches the data in the underlying tables.
Materialized Views can get out of sync with their underlying data. If the status of a View is Stale, you must refresh the View manually to sync it with the table.
Note that until it is refreshed, the View remains searchable.
To refresh a View manually, follow these steps:
-
To find your View, click Data in the top menu, and choose Views.
-
Click Schema.
-
In the Materialization panel, notice that the Status is Stale.
-
Next to the Stale status, click Refresh Data.
Related information