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 the table's partitioning policy. The partitioning policy defines if and how extents (data shards) should be partitioned for a specific table or a materialized view.
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.
.show table TableName policy partitioning
Learn more about syntax conventions.
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the table for which to show the policy details. |
Returns a JSON representation of the policy.
Display the policy at the table level:
.show table MyTable policy partitioning