Search code examples
azureazure-application-insightskql

Azure Application Insights Analytics Query with Cross Cluster Join


I have a cluster receiving telemetry about Page Views, and I have another cluster where I imported some data that will give more insight about those pages, like what feature (business area) they belong to. The problem is that the Join query does not return any value.

Query on AppPageViews

Query on another cluster

Query with Cross Cluster Join

I tried other Join Flavors, but had no success.

I expected to view the AppPAgeViews together with correspondent FeatureId from table k3telemetryformfeatures.


Solution

  • The solution was to invert my query, the native cluster must be selected in context.

    https://learn.microsoft.com/en-us/azure/data-explorer/query-monitor-data#cross-query-of-your-log-analytics-or-application-insights-workspace-and-the-azure-data-explorer-native-cluster