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
Displays statistics of data partitioning for all tables in the database that have a data partitioning policy defined.
Permissions
You must have at least Database User, Database Viewer, or Database Monitor permissions to run this command. For more information, see role-based access control.
Syntax
.show database DatabaseName extents partitioning statistics
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| DatabaseName | string |
✔️ | The name of the database for which to show the partitioning statistics. |
Returns
| Column name | Column type | Description |
|---|---|---|
| TableName | string |
The name of the table |
| PartitioningPolicy | dynamic |
JSON representation of the policy |
| TotalRowCount | long |
Total number of rows in the table* |
| PartitionedRowCount | long |
Number of partitioned rows in the table* |
| PartitionedRowPercentage | real |
Percentage of partitioned rows from all rows in the table* |
* Values may be up to 15 minutes old, as they're taken from a cached summary of the table's extents.