Extract JSON array from object (redshift)
I need to extract data from an array nested inside an object (let’s say the column it lives in is metadata). It looks like the following:
I need to extract data from an array nested inside an object (let’s say the column it lives in is metadata). It looks like the following: