.show database cache policy

Show the database 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 database DatabaseName policy caching

Arguments

DatabaseName - Specify the name of the database.

Returns

Returns a JSON representation of the policy.

Example

The following example shows the table caching policy:

.show database MyDatabase policy caching