Getting a String Instead of Array from Redshift while we dump data from DocumentDb to Redshift using Glue

438 Views Asked by At

I have data that has an array of strings in documentdb. But when I dump to Redshift using glue the whole array is treated as a string. I know that there is no direct way of converting into an array in Redshift but is there any other way to do it?

2

There are 2 best solutions below

0
On

There is no array data type in redshift. The only thing you could do is to explode the array on the way to redshift.

0
On

You can store you data as a Redshift “super” data type as a json list. Would this help in your case?