Hi,
I am a new SAS Viya User. I am trying to connect to the AWS Athena Data warehouse by establishing a ODBC connection. I created a caslib using the caslib statement and assigned the caslib. Can I access the files/tables in the Data warehouse without loading the data to caslib? TIA
Where have you got with establishing an ODBC connection to Athena in SAS?
Perhaps you could try a LIBNAME using the ODBC engine like in these posts:
Solved: SAS, Athena, and Hyphens - SAS Support Communities
Solved: Getting error while testing Athena JDBC/ODBC bridg... - SAS Support Communities
@jayvisw11 - Please update your post as answered in that case.
Two things helped me in resolving the issue.
1. Including the schema option while creating the caslib to establish a connection to Data warehouse via ODBC.
2. Using proc fedsql instead of proc sql to query the DW.
I hope this helps. Thank you! 🙂
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!