Clear schema cache for streaming ingestion

Applies to: ✅ Microsoft FabricAzure Data Explorer

Nodes cache schema of the databases that receive data via streaming ingestion. This process optimizes performance and utilization of resources, but can cause propagation delays when the schema change.

Clear the cache to guarantee that subsequent streaming ingestion requests incorporate database or table schema changes. For more information, see Streaming ingestion and schema changes.

Note

Using these commands can have an adverse effect on the performance of streaming ingestion.

Permissions

You must have at least Database Ingestor permissions to run this command.

Syntax

.clear table TableName cache streamingingestion schema

.clear database cache streamingingestion schema

Learn more about syntax conventions.

Parameters

Name Type Required Description
TableName string ✔️ The name of the table for which to clear the cache.

Returns

This command returns a table with the following columns:

Column Type Description
NodeId string Identifier of the node
Status string Succeeded/Failed

Example

.clear database cache streamingingestion schema

.clear table T1 cache streamingingestion schema
NodeId Status
Node1 Succeeded
Node2 Failed

Note

If the command fails or one of the rows in the returned table contains Status=Failed the command can be safely retried.