Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Failure to connect to Athena with Amazon Athena ODBC, no role_session_name

0

I am trying to use Amazon Athena ODBC 2.x in order to connect to Athena from Power BI. I have tried with both types "IAM credentials" and "Browser Azure AD". But for both ones it fails with the same error reported by the ODBC Driver:

"ODBC: ERROR [HY000] Required connection parameter is missing: role_session_name ERROR [HY000] Required connection parameter is missing: role_session_name"

There is unfortunately no field in the ODBC driver for Athena, in order to specify the required Role Session Name

  • arnaud
    2 years ago

    Finally I could make it work without this error by using Amazon Athena ODBC 1.x instead of version 2

Topics
Analytics
Tags
Amazon Athena
Language
English

asked 2 years ago1.1K views

1 Answer
0

Note that the role session name is a required parameter when connecting to Athena using an IAM role. It is used to create a temporary session with the assumed role, which is necessary for granting the appropriate permissions and access to Athena.

EXPERT

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content