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

Question

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?

Answer 1

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

Answer 2

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