Hi everyone! I'm having trouble getting json array...
# troubleshooting
j
Hi everyone! I'm having trouble getting json arrays from tap-shipstation to de-nest in Postgres. It's work fine with target redshift, where the shipment item info splits off into a child table. Has anyone faced this before? The tap is exactly the same, so I’m thinking it's an issue with the target. Any advice would be appreciated!
Dont have an answer for you, something that will work is to denest in your DW, I prefer DBT for the T step
e
Hey @jo_pearson! Which variants of target redshift and postgres are you using? Some have a config flag or value for flattening
j
Hi @edgar_ramirez_mondragon! I'm using the transferwise variants for both, and have set the data_flattening_max_level to 1000 for both