Other options for "Templating with Variables" for AppInsights?

[avishnyakov]

Hi team,

Documentation on "Templating with Variables" suggest that there are two filters:

https://github.com/grafana/azure-monitor-datasource#templating-with-variables

• AppInsightsMetricNames() | Returns a list of metric names.
• AppInsightsGroupBys(aMetricName) | Returns a list of group bys for the specified metric name.

Is there any option to support raw AppInsight queries?

It would be nice if we could say something like this:

customEvents 
| extend myFile = customDimensions['file']
| distinct myFile 
| order by myFile asc

Can we do this right now or this is something not supported at the moment?

[avishnyakov]

Alright, seems these two are the only once and no raw AppINsights query support is there yet.

https://github.com/grafana/azure-monitor-datasource/blob/9b74f46ec9d856959392f86e5bd7e37eed7d04f0/src/app_insights/app_insights_datasource.ts#L138-L151

Relates to https://github.com/grafana/azure-monitor-datasource/issues/4

Team, how hard would it be to support raw AppInsight queries for template variables? That way we would be able to build dynamic dashboards allowing people to choose values based on real data coming from AppInsights. Instrumentation, monitoring and other scenarios can be made so much easier!

What do you think?