Which column can be used to uniquely identify a row in the Application Insights traces table?

Viewed 34

Does the traces table in Application Insights have a column that uniquely identifies each row in the table, like a primary key?

The only schema documentation I could find, https://docs.microsoft.com/en-us/azure/azure-monitor/reference/tables/traces, suggests the itemId column is a unique identifier:

Unique ID of the telemetry item assigned by the Application Insights ingestion endpoint.

This sounded promising but I wasn't sure if a telemetry item assigned by the ingestion endpoint is the equivalent of a row in the table.

Looking at our production logs in Application Insights I found 72 itemIds recorded more than once in the last 24 hours. So either there is a bug in Application Insights or the itemId doesn't uniquely identify a row in the traces table.

Would any other column, or combination of columns, work to uniquely identify each row in the table?

0 Answers
Related