.alter-merge table retention policy
Change a table'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. The retention policy can be configured for a specific table or materialized view, or for an entire database. The policy then applies to all tables in the database that don't override it.
Syntax
.alter-merge table TableName policy retention PolicyParameters
Arguments
TableName - Specify the name of the table. 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 table Table1 policy retention softdelete = 10d recoverability = disabled