Extracting JSON objects in Athena / Presto for dynamic keys
I have two string formatted columns in my table. One of the columns has json objects in it. The keys in the JSON objects are not fixed - so the problem is I cant use standard json extract functions. Here…