Writing the data into Redshift

[npeddagorla]

Hello I have an use case to write the spatial data into Redshift data base. what are the different ways i can achieve this. I see that redshift have Geometry data type. How can we achieve taht.

[BrandonB]

This article outlines the problem and workaround: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Reading-and-Writing-Spatial-data-fr... 

You may want to convert to GeoJSON by using a Select tool to convert from spatial to VW_String

[npeddagorla]

Hello Brandon this solution does not work for more larger shapes as the length is more 

[BrandonB]

Correct, this topic is addressed in the article that I linked: