This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 78%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
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
Hello @Sam Li (RD-CN) ,
Just checking in to see if the below answer provided by anonymous userChaudhari helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
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
Thank you for your anwser. It is helpful fo us. If ADX can provide a function like ingest_time(), it will be more convenience for us.