.show database policy streamingingestion command
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