.show table cache policy

Show the table 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.


.show table [DatabaseName .]TableName policy caching


DatabaseName - Specify the name of the database. TableName - Specify the name of the table. Use without DatabaseName when running in the required database's context.


The following examples shows the table caching policy:

.show table MyDatabase.MyTable policy caching 
.show table MyTable policy caching