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.
Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Azure Data Explorer
Delete the table's cache policy. To speed up queries on data, the service caches it on its processing nodes, SSD, or even in RAM. The cache policy lets the service describe the data artifacts that it uses so that important data can take priority.
Permissions
You must have at least Table Admin permissions to run this command.
Syntax
.delete table [DatabaseName .]TableName policy caching
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| DatabaseName | string |
The name of the database. Use when running outside the database context that contains the table for which to delete the cache policy. | |
| TableName | string |
✔️ | The name of the table. |
Example
The following example deletes the caching policy.
.delete table MyTable policy caching