Edit

Share via

.show table policy partitioning command

  • Article

Applies to: ✅ Microsoft Fabric ✅ 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