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?

You need to sign in to view this answers