Salta al contenuto
Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
AWS re:Postre:Post
Informazioni su 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
    un anno fa

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

Argomenti
Analisi
Tag
Amazon Athena
Lingua
English
posta un anno fa678 visualizzazioni
1 Risposta
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.

ESPERTO
con risposta un anno fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Contenuto pertinente