Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Writing the data into Redshift

npeddagorla
7 - Meteor

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.

3 REPLIES 3
BrandonB
Alteryx
Alteryx

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
7 - Meteor

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

BrandonB
Alteryx
Alteryx

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

 

BrandonB_0-1632779196602.png

 

Labels
Top Solution Authors