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: ✅ Microsoft Fabric ✅ 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","MaxValue":"2025-07-07 07:53:55"}], "MaxAge": "5m", "HotDateTimeColumn":"dt1"} |
ExternalTable |