How to query data stored in Application insights using Azure Synapse

Question

How to query data stored in Application insights using Azure Synapse

asagrawal 0 Microsoft Employee

Application Insights have telemetry data stored for an application. I want to query this data using Azure Synapse Analytics without exporting data to Synapse. Can someone help me understand the best way to solve this?

1 answer

Your answer

Answer 1

AirGordon 7,165

You can query your Application Insights workspace using Azure Synapse Data Explorer, which is part of Azure Synapse Analytics. https://learn.microsoft.com/en-us/azure/data-explorer/query-monitor-data

Select Add Cluster then provide the Application Insights URL in this format: https://ade.applicationinsights.io/subscriptions/<subscription-id>/resourcegroups/<resource-group-name>/providers/microsoft.insights/components/<ai-app-name>

asagrawal 0 Reputation points Microsoft Employee

2023-06-12T10:19:17.24+00:00

I believe this method will authenticate the same user to that cluster. I have to use a service principal for authentication in this case as the account accessing the synapse workspace will not have access to App Insight Resource.

Is there any way I can use a linked service in Azure synapse Data Explorer?
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-06-20T23:03:26.93+00:00

Hello 18200927

You can follow the below document to use linked service in Azure synapse data explorer.

https://learn.microsoft.com/en-us/azure/synapse-analytics/quickstart-connect-azure-data-explorer#connect-an-azure-data-explorer-database-to-an-azure-synapse-workspace
asagrawal 0 Reputation points Microsoft Employee

2023-06-21T06:44:20.1866667+00:00

Hey @Bhargava-MSFT , I tried to create a linked service to connect to an azure data explorer database. Although, our data is stored in Application Insights. I was not able to see the tables in the data section in Synapse workspace. Can you help me understand what might have went wrong ?
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-06-30T01:54:39.1033333+00:00
Hello asagrawal,

Sorry, I was on vacation.

Were you able to test the linked service connection? I was able to connect to log analytics and see the tables.

This is same for app insights.

As @AirGordon mentioned, please.

Add Cluster in the below format:

For Log Analytics (LA): https://ade.loganalytics.io/subscriptions/<subscription-id>/resourcegroups/<resource-group-name>/providers/microsoft.operationalinsights/workspaces/<workspace-name>

For Application Insights (AI): https://ade.applicationinsights.io/subscriptions/<subscription-id>/resourcegroups/<resource-group-name>/providers/microsoft.insights/components/<ai-app-name>

https://learn.microsoft.com/en-us/azure/data-explorer/query-monitor-data#add-a-log-analyticsapplication-insights-workspace-to-azure-data-explorer-client-tools

and then use this endpoint in the linked service connection.

See the below document for the linked service connection.

https://learn.microsoft.com/en-us/azure/synapse-analytics/quickstart-connect-azure-data-explorer#connect-an-azure-data-explorer-database-to-an-azure-synapse-workspace

a

Share via

How to query data stored in Application insights using Azure Synapse

1 answer

Your answer