How to connect Amazon Athena with IAM Profile authentication

[Hide_Kojima1]

To connect Amazon Athena with IAM Profile, first, create a DSN on your Windows or Mac and set the following:

See: Amazon Athena ODBC Setup Guide for details.

Mac

1. Set the AuthenticationType property to IAM Profile.
2. Set the AWSProfile property to the name of the profile to use.
3. Optionally, set the PreferredRole property to the Amazon Resource Name
   (ARN) of the role you want to assume when authenticating through an external
   credential service.

Windows

1. To access authentication options, open the ODBC Data Source Administrator
   where you created the DSN, then select the DSN, then click Configure, and
   then click Authentication Options.
2. From the Authentication Type drop-down list, select IAM Profile.
3. In the AWS Profile field, type the name of the profile to use.
4. Optionally, in the Preferred Role field, type the Amazon Resource Name (ARN)
   of the role you want to assume when authenticating through an external
   credential service.
5. To save your settings and close the Authentication Options dialog box, click
   OK

Then create an ODBC Data Source on Exploratory Desktop and use the DSN created above.