Accessing AWS Athena Data warehouse via ODBC

[jayvisw11]

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

[SASKiwi]

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]

Hi,
My issue is resolved now. Thank you for your response 🙂

[SASKiwi]

@jayvisw11  - Please update your post as answered in that case.

[jayvisw11]

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! 🙂