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 AWS Access Key ID. For more information about access keys, see AWS security credentialsin the IAM User Guide.

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

Password

Your AWS secret key id. For more information about access keys, see AWS 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 AWS 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>;