I am trying to parse a column that contains either a LIST, a NULL, or a String. As you can see it is the policy action that describes an AWS S3 Bucket.
When I do JSON_ELEMENTS on the column many rows (both NULL, and single String) will disappear.
When I do JSON_ELEMENT I will have to manually define and the values became separate columns.
I would like to have the list be splitted in the same column (different rows) rather than split string in columns.
Can I please have your advice? what is the best practice to deal with this scenario?
Please sign in to leave a comment.