.clear materialized-view data
Clears the data of an existing materialized view.
The data is cleared from the materialized part of the view only. For more details about the materialized part, see how materialized views work. After the materialized view data is cleared, the view will continue processing the source table records ingested since the last materialization time. Use the .show materialized-view command to get the last materialization timestamp.
The difference between this command and dropping and recreating the view (with no backfill) is that using this command preserves all policies set on the materialized view.
Requires Database Admin permissions, or an admin of the materialized view.
Syntax
.clear materialized-view MaterializedViewName data
Example
.clear materialized-view UsersView data