How do I use getschema for customDimensions?

128 views Asked by At

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?

1

There are 1 answers

0
Chris Long On BEST ANSWER

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]