.alter table policy merge command

Applies to: ✅ Azure Data Explorer

Changes the table's merge policy. The merge policy defines if and how Extents (Data Shards) should get merged.

You must have at least Table Admin permissions to run this command.

.alter table TableName policy merge PolicyObject

Learn more about syntax conventions.

.alter table [table_name] policy merge ```
{
  "RowCountUpperBoundForMerge": 16000000,
  "OriginalSizeMBUpperBoundForMerge": 0,
  "MaxExtentsToMerge": 100,
  "LoopPeriod": "01:00:00",
  "MaxRangeInHours": 24,
  "AllowRebuild": true,
  "AllowMerge": true,
  "Lookback": {
    "Kind": "Default"
  }
}```