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

Alteryx designer Discussions

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

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