Clear schema cache for streaming ingestion
Applies to: ✅ Azure 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.