Forum Discussion
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?
UriBarash
Microsoft
MicrosoftADX is an append only data platform . You can insert a new version of the data and filter for the last version using arg_max and materialized views.
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
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
