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

Question

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

Giovanni Lauria · Answer

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.

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

Añade tu respuesta

Contenido relevante