.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.

Permissions

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

Defaults and limits

See defaults and limits.

Syntax

.alter-merge database DatabaseName policy ingestionbatching PolicyObject

Learn more about syntax conventions.

Parameters

Name Type Required Description
DatabaseName string ✔️ The name of the database for which to alter the ingestion batching policy.
PolicyObject string ✔️ A policy object that defines the ingestion batching policy. For more information, see ingestion batching policy.

Examples

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

Note

If you specify only some parameters of a PolicyObject, these parameters will replace the values in the current policy, while the other parameters will remain intact. To set the default values for unspecified parameters, use the alter command command.