Search code examples
azure-application-insightsazure-data-studio

How to query Application Insight data using Azure Data Studio

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?

Solution
    • 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.