Kusto databases, either in Azure Data Explorer or in Fabric KQL Database, 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.
We are proud to announce this command is now Generally Available (GA).
We believe this command gives you an alternative for your data pipelines. Many loading scenarios involve updating records. For instance, ingesting new data in a staging table to then update the records of a main table with those new records. This is now possible with the .update command.
Learn more.