.alter-merge table policy ingestionbatching command
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
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.