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.
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
Hello Brandon this solution does not work for more larger shapes as the length is more
Correct, this topic is addressed in the article that I linked: