.alter-merge database policy ingestionbatching command
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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for