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
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.
You must have at least Database Admin permissions to run this command.
.alter-merge table TableName policy partitioning PolicyObject
Learn more about syntax conventions.
| 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. |
Alter merge the policy at the table level:
.alter-merge table MyTable policy partitioning '{"EffectiveDateTime":"2023-01-01"}'