Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Azure Data Explorer
Changes the 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.
You must have at least Database Admin permissions to run this command.
.alter-merge materialized-view MaterializedViewName policy retention PolicyParameters
Learn more about syntax conventions.
| Name | Type | Required | Description |
|---|---|---|---|
| MaterializedViewName | string |
✔️ | The name of the materialized view. |
| PolicyParameters | string |
✔️ | One or more policy parameters. For more information, see retention policy. |
Sets a retention policy with a 10-day soft-delete period, and disables data recoverability:
.alter-merge materialized-view View1 policy retention softdelete = 10d recoverability = disabled