Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start 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
‎09-27-2021 12:28 PM

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.

Labels:
Reply
0 Likes
3 REPLIES 3
BrandonB
Alteryx
Alteryx
‎09-27-2021 02:24 PM

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

Reply
0 Likes
npeddagorla
7 - Meteor
‎09-27-2021 02:26 PM

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

Reply
0 Likes
BrandonB
Alteryx
Alteryx
‎09-27-2021 02:47 PM

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

 

BrandonB_0-1632779196602.png

 

Reply
0 Likes
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All