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
Show the materialized view cache policy. To speed up queries, data is cached on processing nodes, SSD, or even in RAM. The cache policy describes the data artifacts used, so that more important data can take priority.
.show materialized-view MaterializedViewName policy caching
Learn more about syntax conventions.
| Name | Type | Required | Description |
|---|---|---|---|
| MaterializedViewName | string |
✔️ | The name of the materialized view. |
Returns a JSON representation of the policy.
The following example shows the table caching policy:
.show materialized-view MyMaterializedView policy caching