I’m trying to load a seed file to Redshift. My seed has a column of the SUPER type (has JSON for value), but the value of that column is not how I expect it to be.
The expected value should be:
but when my csv file, no matter how I try to adjust the quotes, I can’t get to this result.
When in my csv file the value is:
I’m getting something like:
I tried any combination of the quotes that I could think of but still couldn’t get the expected result, which means I can’t query this column as a JSON.