.alter-merge materialized-view retention policy

Change a materialized-view's retention policy. The retention policy controls the mechanism that automatically removes data from tables or materialized views. It is used to remove data whose relevance is age-based.

Syntax

.alter-merge materialized-view MaterializedViewName policy retention PolicyParameters

Arguments

MaterializedViewName - Specify the name of the materialized view. PolicyParameters - Define policy parameters, see also retention policy.

Example

Sets a retention policy with a 10 day soft-delete period, and enable data recoverability:

.alter-merge materialized-view View1 policy retention softdelete = 10d recoverability = disabled