How ca we parse JSON / Array of Objects coming as a column?
There is an option to unfold a json for some databases:
You will get the key, value pairs as a new column. If you want to apply specific transformations on a JSON/Array object then you should do that directly at SQL level
That doesn't seem to work for a column containing an array of objects - it doesn't seem to recognize the objects inside the array and does not unfold them. Am I missing something?
needs to be a JSON object column (meaning having a key:value format)