Kusto: Deleting Records

Archived — the legacy netbox_matrix agent is retired after the prod cutover. Kept for historical reference only. For the live pipeline, see Matrix Connector Operations.

Deleting records requires two commands — one for the staging table, one for the materialized view. Deleting from staging alone does not affect the view, and vice versa.

Procedure

// 1. Preview (optional but recommended)
// whatif returns the number of records that would be deleted without actually deleting them.
// whatif does not require .disable — it is a read-only dry run.
.delete table <TableName>_staging records with (whatif=true) <|
  <TableName>_staging
  | where <condition>

.delete materialized-view <ViewName> records with (whatif=true) <|
  <ViewName>
  | where <condition>

// 2. Delete from staging (cleans unprocessed delta records)
.delete table <TableName>_staging records <|
  <TableName>_staging
  | where <condition>

// 3. Delete from view (cleans already-materialized records)
.disable materialized-view <ViewName>

.delete materialized-view <ViewName> records <|
  <ViewName>
  | where <condition>

.enable materialized-view <ViewName>

// 4. Verify
<ViewName>
| where <condition>
| count

Re-enable the view as soon as the delete completes. While disabled, the materialization cycle is paused and all new records accumulate in the delta unprocessed. The larger the delta grows, the more work is required to reconcile it against the materialized part on resume, degrading both materialization and query performance.If the delete fails or is interrupted, re-enable the view immediately with .enable materialized-view <ViewName>, then investigate. The view will resume materializing from where it left off — the failed delete simply has no effect.

Permissions

.delete requires Database Admin permissions. Do not use .purge — it requires additional cluster-level configuration and is intended for compliance use cases only.

Start Here

Operator Guide

Developer Guide

Relationships

Deployment Guide

Archived

API Reference

Kusto: Deleting Records

Procedure

Further Reading

Permissions

​Procedure

​Further Reading

​Permissions

Procedure

Further Reading

Permissions