IAM Role/profile support with Athena ODBC Connector

Use IAM role credentials for an Athena JDBC driver connection

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

Yes the Amazon Athena ODBC driver supports authentication using IAM profile (see "Using an IAM profile on Windows" in page 15 of the ODBC driver guide). 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