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?

CodePudding user response：

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

CodePudding user response：

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