This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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 .
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 .
Note : I will write up article later on sepcturm looks pretty powerful with Alteryx In DB tools .
Did you ever find a solution to this?
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 .