IAM credentials - Amazon Athena
Authentication typeUser IDPasswordSession token
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

IAM credentials

You can use your IAM credentials to connect to Amazon Athena with the ODBC driver using the connection string parameters described in this section.

Authentication type

Connection string name Parameter type Default value Connection string example
AuthenticationType Required IAM Credentials AuthenticationType=IAM Credentials;

User ID

Your Amazon Access Key ID. For more information about access keys, see Amazon security credentialsin the IAM User Guide.

Connection string name Parameter type Default value Connection string example
UID Required none UID=AKIAIOSFODNN7EXAMPLE;

Password

Your Amazon secret key id. For more information about access keys, see Amazon security credentialsin the IAM User Guide.

Connection string name Parameter type Default value Connection string example
PWD Required none PWD=wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKE;

Session token

If you use temporary Amazon credentials, you must specify a session token. For information about temporary credentials, see Temporary security credentials in IAM in the IAM User Guide.

Connection string name Parameter type Default value Connection string example
SessionToken Optional none SessionToken=AQoDYXdzEJr...<remainder of session token>;