Passer au contenu
En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post
À propos de 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
    il y a un an

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

Sujets
Analytique
Balises
Amazon Athena
Langue
English
demandé il y a un an699 vues
1 réponse
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
répondu il y a un an

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Contenus pertinents