I had previously had asked a question, and it was answered (AWS Athena Parse array of JSON objects to rows), about parsing JSON arrays using Athena but running into a variation.

I have a source table which have 300 columns and the number of columns might grow so I’m trying to construct a query where I want to insert into target table only a few columns and the other data must be merged in json object in a specific column.