.alter-merge table policy ingestionbatching command
Sets the table's ingestion batching policy to determine when data aggregation stops and a batch is sealed and ingested. The ingestion batching policy applies to queued ingestion.
If the policy isn't set for a table, the database-level policy applies. If the policy isn't set at the database-level, the default values apply.
Permissions
You must have at least Table Admin permissions to run this command.
Defaults and limits
See defaults and limits.
Syntax
.alter-merge
table
[ DatabaseName.
]TableName policy
ingestionbatching
PolicyObject
.alter-merge
tables
(
Table1 ,
Table2 [,
...])
policy
ingestionbatching
PolicyObject
Learn more about syntax conventions.
Parameters
Name | Type | Required | Description |
---|---|---|---|
TableName | string |
✔️ | The name of the table to alter. |
DatabaseName | string |
The name of the database. When you run the command from the database context that contains the table to alter, DatabaseName is not required. | |
PolicyObject | string |
✔️ | A serialized JSON policy object. 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 table MyDatabase.MyTable 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 table MyDataMyDatabase.MyTable policy ingestionbatching
```
{
"MaximumBatchingTimeSpan" : "00:00:45",
"MaximumNumberOfItems" : 450
}
```
Note
If you specify only some parameters of a PolicyObject, they 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.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om