Find the node name of the JSON key from nested JSON
I have below JSON data:
Athena find node name of json key from nested json
I have below json data
AWS Athena Parse array of JSON objects to rows
Working with AWS Athena and trying to parse data found in a column with a defined data type of array so that each JSON object in the array is broke out into a separate row.
when I run this query: