Kusto databases, either in Fabric (KQL Database) or in Azure (Azure Data Explorer), are optimized for append ingestion.
In recent years, we've introduced the .delete command, allowing you to selectively delete records.
In February, we introduced the .update command in public preview. This command allows you to update records by deleting existing records and appending new ones in a single transaction.
Today, the .update is Generally Available (GA)!
During the public preview, we introduced two syntaxes: the simplified and expanded syntax. We only GA the expanded syntax (the most powerful) and are deprecating the simplified syntax. This is due to the simplified syntax being confusing in some scenarios.
We encourage you to go through the many examples of the online documentation page to familiarize yourself with the syntax.
As usual, we are looking forward for your feedback and hope this makes you more productive in Kusto!
Microsoft