loading seed with SUPER type to Redshift

Help
,
1

Hi,

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:
{"parameter":"82c4aca8-7fca-4f6d-a964-78b116ed9aa9"}
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:
"{""parameter"":""82c4aca8-7fca-4f6d-a964-78b116ed9aa9""}
I’m getting something like:
"{\"parameter\":\"82c4aca8-7fca-4f6d-a964-78b116ed9aa9\"}
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.
Any suggestions?

2

Hi
You need to define a yml for seed telling dbt the columname and colunntypes … check the docs