Hi @SASUser_86
SAS 9.4M6 willl work fine. SAS/ACCESS Interface to ODBC has been around a long time. No problems there.
You didn't mention this, but I will bring it up again because it is common. I know because this has hit me more times than I care to admit. I feel like an idiot EVERY SINGLE TIME. Make sure there are no stray white space characters in your code. I usually remove all white space and try it. Something like this...
/* simplified example */
libname athena odbc
complete="DRIVER={Simba Athena ODBC Driver};AwsRegion=us-east-1;S3OutputLocation=s3://bogus-athena-results/;AuthenticationType=IAM Profile;AwsProfile=617292732428-jbsandbox;" schema=somedb;
I assume that your SAS server is running on Linux. There may be an issue with the ODBC configuration. I know if you have SAS/ACCESS Interface to MS SQL installed, someone must play tricks with the ODBC Driver Manager.
It is important to note, everything specified in the CONNECT= option (between the "") comes from the ODBC driver documentation (see link below). The example I used is overly complicated for purposes. I assume that you don't need to use a proxy server. Then again, that could actually be the problem - but, I doubt it.
Here is an example that matches what you are trying to do.
/* simplified example */
libname athena odbc
complete="DRIVER={Simba Athena ODBC Driver};
AwsRegion=us-east-1;
S3OutputLocation=s3://bogus-athena-results/;
AuthenticationType=IAM Profile;
AwsProfile=617292732428-jbsandbox;" schema=somedb;
Simba ODBC Driver Documentation
When I have issues like this, I usually:
Try to connect using a simple ODBC query tool - dbsquirrel, Excel, etc.
Put an error (say a bad S3 bucket) in the code to see if the remote source is seeing the connection request. You will know because Athena will complain about the bucket not existing.
SAS can run on cloud environments. We have lots of customers doing it. Check out our partnership with Microsoft. Cool stuff. I haven't announced it, but I moved from Product Management to our SAS Cloud group a couple of months ago. The cloud is a lot of fun. I highly recommend spending some quality time with it.
This SAS Communities post may help - https://communities.sas.com/t5/Administration-and-Deployment/Connect-SAS-to-AWS-Athena-via-ODBC/td-p/619351
Let me know how it goes,
Jeff
... View more