You can refresh a view manually, so that its data matches the data in its underlying tables.

Materialized views can get out of sync with their underlying data. If the status of a view is Stale, you’ll need to refresh the view manually, so that it is in sync with the underlying table. Until you refresh it, the view will still be searchable, but the data will not be up-to-date.

To refresh a view manually:

  1. To find your view, click Data in the top menu, and choose Views.

  2. Click the name of your view.

  3. Click Schema.

  4. Under Materialization, choose Dematerialize.