.alter-merge database policy ingestionbatching command

  • Article

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.

Related content