.alter-merge database policy ingestionbatching command

Applies to: ✅ Azure Data Explorer

Sets the ingestion batching policy to determine when data aggregation stops and a batch is sealed and ingested. The ingestion batching policy applies to queued ingestion.

When setting the policy for a database, it applies for all its tables, except tables that were set with their own ingestion batching policy. If the policy isn't set for a database, the default values apply.

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

See defaults and limits.

.alter-merge database DatabaseName policy ingestionbatching PolicyObject

Learn more about syntax conventions.

The following command sets a batch ingress data time of 30 seconds, for 500 files, or 1 GB, whichever comes first.

.alter-merge database MyDatabase policy ingestionbatching
```
{
    "MaximumBatchingTimeSpan" : "00:00:30",
    "MaximumNumberOfItems" : 500,
    "MaximumRawDataSizeMB" : 1024
}
```

The following command sets a batch ingress data time of 45 seconds, for 450 files, or the previous value of MaximumRawDataSizeMB, whichever comes first.

.alter-merge database MyDatabase policy ingestionbatching
```
{
    "MaximumBatchingTimeSpan" : "00:00:45",
    "MaximumNumberOfItems" : 450
}
```

• .alter-merge table ingestionbatching policy