Update records in a Kusto Database (public preview)

Kusto databases, either in Azure Data Explorer or in Fabric KQL Database, are optimize for append ingestion. In recent years, we've introduce the [.delete command](https://learn.microsoft.com/en-us/azure/data-explorer/kusto/concepts/data-soft-delete) allowing you to selectively delete records. Today we are introducing the [.update command](https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/update-table-command). This command allows you to update records by deleting existing records and appending new ones in a single transaction. We believe this new 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. The command is in public preview and we are looking forward for your feedback! [Learn more](https://techcommunity.microsoft.com/t5/blogs/blogworkflowpage/blog-id/AzureDataExplorer/article-id/505) * Azure Data Explorer * Features * [ Azure Data Explorer](https://azure.microsoft.com/en-gb/products/data-explorer/)