Cross Service Query - Azure Monitor and Azure Data Explorer
Published Nov 24 2020 12:32 AM 5,360 Views
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.
Version history
Last update:
‎Apr 08 2022 11:14 AM
Updated by: