.show table policy partitioning command
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.
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 table TableName policy partitioning
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the table for which to show the policy details. |
Returns
Returns a JSON representation of the policy.
Example
Display the policy at the table level:
.show table MyTable policy partitioning