1

I have the following connectivity options in my Azure Data Studio setup:

enter image description here

How can I connect may Azure Data Studio to an Application Insight instance?

Allan Xu
  • 7,998
  • 11
  • 51
  • 122
  • If you Application Insights is Workspace-based then all data (in slightly different schema) is stored in Workspace. For instance, AppRequests represent requests table in Application Insights. – ZakiMa Dec 07 '22 at 09:48
  • Sorry, not following. Can you elaborate or provide a link to documentation? – Allan Xu Dec 07 '22 at 18:43
  • Application Insights has two type of resources - Classic (backed up by internal Kusto) and Workspace-based (backed by Azure Monitor Log Analytics Workspace). Here is how you can migrate your Classic resource: https://learn.microsoft.com/en-us/azure/azure-monitor/app/convert-classic-resource – ZakiMa Dec 07 '22 at 18:47

1 Answers1

1
  • In Azure Portal, Create a Log Analytics workspace.

enter image description here

  • Copy the workspace ID which is useful for later to connect Azure DataStudio.

enter image description here

Create Application Insights

  • Select the Resource Mode as Workspace-based.
  • In Log Analytics Workspace, select the Workspace which we have created in the first step. Click on Review + create.

enter image description here

  • Open the Azure Data Studio => New Connection.

  • Provide the Workspace ID which we have copied from Portal => Log Analytics Workspace.

  • In Account => Add Account => Login with your Azure Subscription ID.

  • Click on Connect. enter image description here

enter image description here

  • You can see the Azure Data Studio is now connected to our provided Log Analytics Workspace. enter image description here

  • Now you can query the logs by using the New query option. enter image description here

References taken from MSDoc.

Harshitha
  • 3,784
  • 2
  • 4
  • 9
  • This approach does not query the Application Insight data. It query diagnostics of how Application Insight operates. Mind the differences. – Allan Xu Dec 07 '22 at 18:41
  • @AllanXu, this is not correct. In this case Diagnostic Settings exports data sent to Application Insights. Though I think you can achieve almost the same without extra export step by migrating Classic AI resource to Workspace-based. – ZakiMa Dec 07 '22 at 18:46
  • @AllanXu - If you don't want the diagnostic of Application Insights please ignore the export part. – Harshitha Dec 08 '22 at 02:08
  • As I have already mentioned in the answer to select the resource mode of AI as Workspace based.Please refer this [MSDoc](https://learn.microsoft.com/en-us/azure/azure-monitor/app/create-workspace-resource) once. – Harshitha Dec 08 '22 at 02:15
  • Then I even more confused. You added diagnostic settings to a separate log analytics workspace and pointed the data studio there. Does this approach work when you don't include diagnostic data step? – Allan Xu Dec 08 '22 at 19:57
  • Would you be able to provide the steps where there is no AI diagnostic settings involved? The laser focus and the scope of this question is only AI data not its internal operational diagnostic data. – Allan Xu Dec 08 '22 at 19:59
  • Sure,will ignore the AI diagnostic setting step and will update the answer. – Harshitha Dec 09 '22 at 00:11
  • @AllanXu - Please check the answer now.Do let me know if you want me to provide more details. – Harshitha Dec 09 '22 at 00:17