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