.alter-merge table policy partitioning command
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
Changes 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 Admin permissions to run this command.
Syntax
.alter-merge table TableName policy partitioning PolicyObject
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the table. |
| PolicyObject | string |
✔️ | A serialized array of one or more JSON policy objects. For more information, see partitioning policy. |
Example
Alter merge the policy at the table level:
.alter-merge table MyTable policy partitioning '{"EffectiveDateTime":"2023-01-01"}'