Blog Post

Azure Observability Blog
1 MIN READ

Cross Service Query - Azure Monitor and Azure Data Explorer

OREN_SALZBERG's avatar
OREN_SALZBERG
Icon for Microsoft rankMicrosoft
Nov 24, 2020
Azure Monitor and Azure Data Explorer cross-service querying
This experience enables you to query Azure Data Explorer in Azure Log Analytics/Application Insights tools (See more info here),
and the ability to query Log Analytics/Application Insights from Azure Data Explorer tools to make cross resource queries. (See more info here.),

For example (querying Azure Data Explorer from Log Analytics):

Where the outer query is querying a table in the workspace, and then joining with another table in an Azure Data Explorer cluster (in this case, clustername=help, databasename=samples) by using a new "adx()" function, like how you can do the same to query another workspace from inside query text.
Both experiences are in Public Preview.
Updated Apr 08, 2022
Version 10.0
azure monitor

4 Comments

Sort By
  • OREN_SALZBERG's avatar
    OREN_SALZBERG
    Icon for Microsoft rankMicrosoft
    Feb 07, 2021

    You are correct on your options. regarding performance issues, I have tested the feature with several environments and many early onboarders to our private preview, and couldn't find any performance penalties.

     

    Please note that this service is still in public preview, with support, and we still work on improving any issues encountered using the service.

  • maayanh's avatar
    maayanh
    Copper Contributor
    Feb 07, 2021

    OREN_SALZBERG Thank you. I'm trying to understand if there is a performance penalty to the cross-service query, similar to the penalties of cross-database queries done over linked databases. 

    For example, if I have ADX + Log Analytics, and I need a query which combines data from both sources.

    If I understand correctly, I can either:

    1. Periodically copy the data from Log Analytics into ADX, and perform an ADX-only query

    2. Perform a cross service ADX+Log Analytics query

    So my question is: is there a significant performance penalty for the 2nd option over the 1st, in terms of the query alone.

     

  • OREN_SALZBERG's avatar
    OREN_SALZBERG
    Icon for Microsoft rankMicrosoft
    Feb 07, 2021

    Sure maayanh . There are customers who are having an Azure Data Explorer cluster along with their Log Analytics workspaces, there are times on which the customer want to join the two data sources either for a query result or a dashboard, in these cases he can copy his data out side of the cluster or workspace (which requires him to have a copy of the data, hence probably pay more, or he can use the cross service ability to connect the two services.

  • maayanh's avatar
    maayanh
    Copper Contributor
    Feb 07, 2021

    Can you explain the considerations that should be taken when planning to use cross-service querying vs. other solutions (such as copying the data from the other service into ADX)? I'm especially interested in performance considerations.