Forum Discussion

ashgoel1895

Copper Contributor

Dec 02, 2020

Is there any way to update data in ADX?

I know that ADX is read-only but if you did need to update data in ADX what would be the best practice?

AMA

ashgoel1895

Copper Contributor

Dec 02, 2020

UriBarash - Thanks for your response. Do rows in ADX have a version number that we can utilise for this purpose or would it be our responsibility to have this in our data model?

UriBarash

Microsoft

Dec 02, 2020

ashgoel1895 - Rows do not have a unique ID but you can add one (before you ingest or using an update policy with new_guid() )

https://docs.microsoft.com/en-us/azure/data-explorer/kusto/management/updatepolicy

https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/newguidfunction