Extract json value in a dynamic way

Hi admin,
I encounter an issues below:
{“notifications”: {“4”: 1, “5”: 1, “6”: 1, “18”: 1}}

we have a Json string above and I would like to convert all the key and value in a tabular structural format in a dynamic way instead of hardcoded every key as column, would you have any idea?
I know dremio have a flatten function but it just support for array value.

lots of thanks!

1 Like