Edit

Share via

.alter table policy merge command

  • Article

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer

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

Permissions

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

Syntax

.alter table TableName policy merge PolicyObject

Learn more about syntax conventions.

Parameters

Name Type Required Description
TableName string ✔️ The name of the table to alter.
PolicyObject string ✔️ A serialized JSON policy object. See merge policy.

Example

.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"
  }
}```