community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

AWS Redshift spectrum Questions

Asteroid

Redshift spectrum is new service provided under AWs Redshift - simple terms i create external table point to S3 , Easier to manage. I was able to get the Redshift ODBC working .

Question -

1. Redshift spectrum Tables / Schema are not visible in the Visual query builder , but they are accessible through the SQL editor 

2. Retrieving data works well for  2 million or around 1.8GB and the process hangs do i need to change any setting to allow more GB .

 

Screenshots attached

 

del2.jpgdel1.jpg

 

 

Note : I will write up article later on sepcturm looks pretty powerful with Alteryx In DB tools .

 

Meteor

Did you ever find a solution to this? 

Asteroid

Yes

1. Update Redshift Driver from AWS site

2. Use In-DB for Data analysis - The size issue is mainly becuase of the size of internal memory and page size .  Best thing is to avoid bringing large amount of data .

 

Thanks

Sathiya

Labels