.show materialized-view policy partitioning command

Applies to: ✅ Azure Data Explorer

Displays the materialized view's partitioning policy. The partitioning policy defines if and how extents (data shards) should be partitioned for a specific table or a materialized view.

Syntax

.show materialized-view MaterializedViewName policy partitioning

Learn more about syntax conventions.

Parameters

Name Type Required Description
MaterializedViewName string ✔️ The name of the materialized view.

Returns

Returns a JSON representation of the policy.

Example

Delete the policy at the materialized view level:

.show materialized-view MyMaterializeView policy partitioning