.show query acceleration policy command (preview)
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] | { "IsEnabled": true, "Hot": "1.00:00:00"} |
ExternalTable |