I have an Athena Table with 1000 rows and 2 fields. One field contains the an ID, and the second field contains a JSON blob with 50 key pair values.

What would be a good way to extract the JSON key pairs into a table format that keeps the original ID as primary key?

About the author

Related Post