Suggest an Idea

[Sebastian_Linser]

Support IAM Profile as Authentication Type with AWS Athena in Qlik Sense SaaS. For the moment Qlik supports:

Default credentials	Authenticate using default credentials.
IAM Credentials	Authenticate using Access Key, Secret Key, and Session Token.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Athena...

[P-O_Davidson]

Hi,

The ODBC driver used in the Athena Connector has support for use of IAM Profile, although it is not exposed in the Qlik Sense definition dialog. There are no immediate plans to add this in, but the parameters needed can be set in the Advanced section at the bottom of the dialog.

Here is the description from the driver documentation:

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 Preferred_Role property to the Amazon Resource Name (ARN) of the role you want to assume when authenticating through an external credential service

I hope this helps.

Thanks,
P-O Davidson