.show materialized view cache policy

Show the materialized view cache policy. To speed up queries on data, Azure Data Explorer caches it on its processing nodes, SSD, or even in RAM. The cache policy lets Azure Data Explorer describe the data artifacts that it uses so that important data can take priority.

Syntax

.show materialized-view MaterializedViewName policy caching

Arguments

MaterializedViewName - Specify the name of the materialized view.

Returns

Returns a JSON representation of the policy.

Example

The following example shows the table caching policy:

.show materialized-view MyMaterializedView policy caching