.alter materialized-view policy merge command

  • Article

Applies to: ✅ Azure Data Explorer

Changes the materialized view'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 materialized-view MaterializedViewName policy merge PolicyObject

Learn more about syntax conventions.

Parameters

Name Type Required Description
MaterializedViewName string ✔️ The name of the materialized view.
PolicyObject string ✔️ A policy object used to set the merge policy. For more information, see merge policy.

Example

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