.alter cluster policy query_weak_consistency command

Applies to:✅ Azure Data Explorer

Sets the cluster's query weak consistency policy, overriding the current policy, and then returns the updated policy. The updated policy can be later viewed using the show command. If not altered, the default policy applies.

You must have AllDatabasesAdmin permissions to run this command.

.alter cluster policy query_weak_consistency PolicyObject

.alter-merge cluster policy query_weak_consistency PolicyObject

Learn more about syntax conventions.

JSON serialization of the updated query weak consistency policy object

alter command:

.alter cluster policy query_weak_consistency ```{
   "PercentageOfNodes": 10,
   "MinimumNumberOfNodes": 2,
   "MaximumNumberOfNodes": 20,
   "SuperSlackerNumberOfNodesThreshold": -1,
   "EnableMetadataPrefetch": false,
   "MaximumLagAllowedInMinutes": 10,
   "RefreshPeriodInSeconds": 300
   }```

Output

For demonstrating the alter-merge, we'll assume the following policy is set prior to executing the command:

{
  "PercentageOfNodes": 20,
  "MinimumNumberOfNodes": 10,
  "MaximumNumberOfNodes": 100, 
  "SuperSlackerNumberOfNodesThreshold": -1,
  "EnableMetadataPrefetch": false,
  "MaximumLagAllowedInMinutes": 5,
  "RefreshPeriodInSeconds": 30
}

alter-merge command:

.alter-merge cluster policy query_weak_consistency @'{"PercentageOfNodes": 30, "MaximumLagAllowedInMinutes": 15}'

Output

As can be seen, only PercentageOfNodes and MaximumLagAllowedInMinutes were modified (whereas if the alter command was used instead, the remaining properties would be also modified, and set to their defaults).