Athena Queries for Nested JSON - SuperCowPowers/workbench GitHub Wiki

If you have Nested JSON loaded in as string types in Athena, you can run queries like this to pull out fields from the JSON:

Lets say 'dns' is a nested JSON field.

 query = "select json_extract_scalar(dns, '$.rrtype') rrtype from heavy_dns"

References:

• https://aws.amazon.com/blogs/big-data/simplify-querying-nested-json-with-the-aws-glue-relationalize-transform/