[SQL] How to flatten a json array string in Redshift

I have a table like this:

id stage(varchar)
1 ["a","b"]
2 ["c"]


and I need to retrieve the data as the following format:

id stage
1 a
1 b
2 c



How should I write my SQL in AWS Redshift?

Continue reading...