12-09-2014 11:12 PM
Just wondering if anybody has utilised SAS BASE and Amazon Redshift. The company that I work for is migrating data to Amazon Redshift... I would appreciate any tips for connecting SAS BASE to to a Redshift Server.
12-15-2014 11:07 AM
Looking at the blurb on Amazon Redshift, it allows users to connect via a wide range of methods including ODBC, so should be relatively straightforward. I would imagine that once the driver is up and running then:
connect to redshift (schema=...) /* options for the driver */;
create table XYZ as
select * from connection to redshift (...);
I would imagine the biggest problem would be overcoming the constant "would you like to use Amazon Prime" messages you get upon any change to anything on their systems (yes, that's off topic!).