azure-application-insightsazure-data-explorerms-app-analytics

How do I use getschema for customDimensions?

I've used a query like

requests
| getschema

to get a table containing the names and types of all columns in the requests table. How can I get the same result for requests.customDimensions?

Solution

  • It looks like this can be done using buildschema and then transforming the output into a consumable format (thanks Dmitry Matveev for helping me out with that piece 🙂):

    requests
| summarize schema=buildschema(customDimensions)
| mvexpand bagexpansion=array schema
| project name=schema[0], type=schema[1]