.alter database streaming ingestion policy

Change the database streaming ingestion policy. Use the streaming policy to manage streaming ingestion for databases and tables.

Use in low latency scenarios, where ingestion time is less than 10 seconds for varying data volume. You can optimize processing for many tables in one or more databases, when tables receive a few records per second, whereas the ingestion volume is 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. Streaming ingestion must be enabled at the cluster level before it can be used at the database level.

Syntax

.alter database DatabaseName policy streamingingestion PolicyObject

Arguments

  • DatabaseName - Specify the name of the database.
  • PolicyObject - Define a policy object. For more information, see the streaming policy.

Returns

Returns a JSON representation of the policy.

Example

The following command enables streaming ingestion and determines the suggestion allocated rate for the database:

.alter database MyDatabase policy streamingingestion 
'{"IsEnabled": true, "HintAllocatedRate": 2.1}'