.delete table policy streamingingestion command
Applies to: ✅ Azure Data Explorer
Delete the table streaming ingestion policy. Use the streaming policy to manage streaming ingestion for databases and tables.
Streaming ingestion is targeted for scenarios that require low latency, with an ingestion time of less than 10 seconds for varied volume data. It's used to optimize operational processing of many tables across one or more databases. Each table receives a small stream of data (a few records per second), but the total data ingestion volume is high (thousands of records per second).
Use the classic (bulk) ingestion instead of streaming ingestion when the amount of data grows to more than 4 Gb per hour per table.
To learn how to implement streaming ingestion, see streaming ingestion.
Permissions
You must have at least Table Admin permissions to run this command.
Syntax
.delete table TableName policy streamingingestion
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the table. |
Example
The following command deletes the streaming ingestion policy:
.delete table MyTable policy streamingingestion
Related content
- Streaming ingestion policy
- .show database policy streamingingestion command
- .show table policy streamingingestion command
- .alter table policy streamingingestion command
- .alter-merge table policy streamingingestion command
- .delete database policy streamingingestion command
- Streaming ingestion and schema changes