This message was deleted.

you have to use JSON_VALUE() to pull out individual values ... then they can be treated as individual fields ... is this what you were looking for?

Not really, I want to get the grouping of keys like in the screenshot

So is it JSON_PATHS() that you are looking for?

JSON_KEYS

return an array, and you want to make it a multi-value dimension (those group as you desire). What you need is some function that takes an array and gives you a MV. I am not sure that a direct function like that exists @Clint Wylie can tell me if I missed it. As a workaround you could join the array into a string and then split the string into an MV. Try

STRING_TO_MV(MV_TO_STRING(JSON_KEYS("details", '$.'), '#'), '#')

Thanks this works awesome