.show database policy streamingingestion command

Applies to: ✅ Azure Data Explorer

Display the database's 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, in one or more databases, where the stream of data into each table is relatively small (a few records per second) but the overall 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 Database User, Database Viewer, or Database Monitor permissions to run this command. For more information, see role-based access control.

Syntax

.show database DatabaseName policy streamingingestion

Learn more about syntax conventions.

Parameters

Name Type Required Description
DatabaseName string ✔️ The name of the database.

Example

The following command shows the streaming ingestion policy:

.show database MyDatabase policy streamingingestion