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
Shows the query acceleration policy of a specific external delta table, or for all external delta tables in the database that have a query acceleration policy set.
Permissions
You must have at least Database monitor or Database viewer permissions to run this command.
Syntax
.show external table ExternalTableName policy query_acceleration
.show external table * policy query_acceleration
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| ExternalTableName | string |
The name of the external delta table. |
Returns
The command returns a table with a record per external table with the following columns:
| Column | Type | Description |
|---|---|---|
| PolicyName | string |
The name of the policy - QueryAcceleration |
| EntityName | string |
The fully qualified name of the entity: [DatabaseName].[ExternalTableName] |
| Policy | string |
A JSON-serialization of the query acceleration policy that is set on the table |
| ChildEntities | string |
The child entities this policy affects - null |
| EntityType | string |
The type of the entity the policy applies to - ExternalTable |
Example
.show external table MyExternalTable policy query_acceleration
Output
| PolicyName | EntityName | Policy | ChildEntities | EntityType |
|---|---|---|---|---|
| QueryAccelerationPolicy | [MyDatabase].[MyExternalTable] | {<br> "IsEnabled": true,<br> "Hot": "1.00:00:00",<br> "HotWindows": [{"MinValue":"2025-07-06 07:53:55.0192810","MaxValue":"2025-07-06 07:53:55.0192814"}], "MaxAge": "5m"} |
ExternalTable |