Update records in a Kusto Database (public preview)
Share
Services
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/)
What else is happening at Microsoft Azure?
Read update
Services
Share
Generally Available: Regional Disaster Recovery by Azure Backup for AKS
November 22nd, 2024
Services
Share
Generally Available: Enhancements on Azure Container Storage for performance, scalability, and operational insights
November 19th, 2024
Services
Share
Read update
Services
Share