.alter database ingestion batching policy

Set the ingestion batching policy to determine when data aggregation stops and a batch is sealed and ingested. The policy applies at the database or table level.

If the policy is set to null, default values are used. Default values are:

  • Batch time of 5 minutes
  • 1000 items
  • Total size of 1 GB
  • Or default cluster settings

Ingestion batching limits

Type Default Minimum Maximum
Number of items 1000 1 2000
Data size (MB) 1000 100 1000
Time 5 minutes 10 seconds 15 minutes

Syntax

.alter database DatabaseName policy ingestionbatching PolicyObject

Arguments

  • DatabaseName - Specify the name of the database.
  • PolicyObject - Define a policy object. For more information, see ingestion batching policy.

Example

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

.alter database MyDatabase policy ingestionbatching @'{"MaximumBatchingTimeSpan":"00:00:30", "MaximumNumberOfItems": 500, "MaximumRawDataSizeMB": 1024}'

Next steps