topic Re: Accessing AWS Athena Data warehouse via ODBC in SAS Viya

Accessing AWS Athena Data warehouse via ODBC

jayvisw11 — Mon, 18 Oct 2021 15:12:11 GMT

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

Re: Accessing AWS Athena Data warehouse via ODBC

SASKiwi — Mon, 18 Oct 2021 23:35:33 GMT

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

Re: Accessing AWS Athena Data warehouse via ODBC

jayvisw11 — Tue, 19 Oct 2021 19:08:33 GMT

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

Re: Accessing AWS Athena Data warehouse via ODBC

SASKiwi — Tue, 19 Oct 2021 19:17:26 GMT

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

Re: Accessing AWS Athena Data warehouse via ODBC

jayvisw11 — Fri, 22 Oct 2021 12:16:31 GMT

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