.delete materialized-view policy retention command
Applies to: ✅ Azure Data Explorer
Delete 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. 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
.delete materialized-view MaterializedViewName policy retention
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| MaterializedViewName | string |
✔️ | The name of the materialized view for which to delete the retention policy. |
Example
The following command deletes the retention policy for a materialized view named MyMaterializedView.
.delete materialized-view MyMaterializedView policy retention