Is there a way to get unique id of each row / record in Azure Data Explorer

Sam Li (RD-CN) 21 Reputation points
2021-05-06T06:19:02.203+00:00

In our project, we need to find the unique id of each row or record in azure data explorer to corelate different tables or data sources. But we don't design an id for it. Is there a way to get the internal id for each row or record in azure data explorer? We have googled the question, but no answer right. It is very important for our application. Can anyone give comments on this?

Thanks

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
458 questions
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,426 Reputation points
    2021-05-06T08:19:38.957+00:00

    Probably try creating a view on top of table and have one auto generated incremental column. Use this view to join other tables/views.


    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav


0 additional answers

Sort by: Most helpful