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 statistics for query acceleration for a specific external delta table, or 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 operations query_acceleration statistics
.show external tables operations query_acceleration statistics
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| ExternalTableName | string |
The name of the external table. |
Returns
The command returns a table with a record per external table that has a non-null policy, with the following columns:
| Column | Type | Description |
|---|---|---|
| ExternalTableName | string |
The name of the external table |
| IsEnabled | bool |
Indicates whether the external has a query acceleration policy enabled |
| Hot | timespan |
The hot period defined in the query acceleration policy |
| HotSize | long |
The total size on disk (in bytes) of data files accelerated due to the query acceleration policy |
| LastUpdatedDateTime | datetime |
Indicates the last datetime when the internal representation of the table was successfully refreshed |
| AccelerationPendingDataFilesCount | long |
The total number of data files that are pending acceleration |
| AccelerationPendingDataFilesSize | long |
The total size of data files that are pending acceleration |
| AccelerationCompletePercentage | double |
The percentage of artifacts that are accelerated, out of the total artifacts that are able to be accelerated |
| NotHealthyReason | string |
Describes the reason for query acceleration not being healthy. Empty if healthy |
Example
.show external table MyExternalTable operations query_acceleration statistics
Output
| ExternalTableName | IsEnabled | Hot | HotSize | LastUpdatedDateTime | AccelerationPendingDataFilesCount | AccelerationPendingDataFilesSize | AccelerationCompletePercentage | NotHealthyReason |
|---|---|---|---|---|---|---|---|---|
| MyExternalTable | True | 1.00:00:00 | 37 | 56877928187 | 2024-08-13 19:54:47.5868860 | 0 | 100 | |
| MyExternalTable2 | True | 1.00:00:00 | 104 | 60467660293 | 2024-08-13 19:54:47.5868860 | 0 | 100 |