IAM Role/profile support with Athena ODBC Connector

Question

When using Athena ODBC on Windows Computer/Laptop, is it possible to use IAM role instead of creating IAM access key and secret access key? Is it even possible? unable to get clear mention about this.

Answer

[Use IAM role credentials for an Athena JDBC driver connection](https://aws.amazon.com/premiumsupport/knowledge-center/athena-iam-jdbc-driver/?nc1=h_ls)

This is a method with the JDBC driver. You could also apply it to the ODBC driver, I guess.

Answer

Yes the [Amazon Athena ODBC driver](https://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc.html#connect-with-odbc-driver-and-documentation-download-links) supports authentication using IAM profile (see "Using an IAM profile on Windows" in page 15 of the [ODBC driver guide](https://s3.amazonaws.com/athena-downloads/drivers/ODBC/SimbaAthenaODBC_1.1.19.1002/docs/Simba+Amazon+Athena+ODBC+Connector+Install+and+Configuration+Guide.pdf)). However, on your Windows laptop, you still need use an IAM user credentials (access key + secret access key) to assume that IAM role. For details how to configure the credential file, please refer to https://docs.aws.amazon.com/cli/latest/userguide/cli-configure-role.html#cli-role-overview

IAM Role/profile support with Athena ODBC Connector

관련 콘텐츠