In many situations it may be preferable to use an IAM role for authentication instead of the direct security credentials of an AWS root user.Īn AWS role may be used instead by specifying the RoleARN. The CData Data Provider for Amazon Athena 2018 will automatically obtain your IAM Role credentials and authenticate with them. To do so, set UseEC2Roles to true and leave AccessKey and SecretKey empty. If you are using the CData Data Provider for Amazon Athena 2018 from an EC2 Instance and have an IAM Role assigned to the instance, you can use the Click Continue to Security Credentials and expand the Access Keys section to manage or create root account access keys.Select your account name or number and select My Security Credentials in the menu that is displayed.Sign into the AWS Management console with the credentials for your root account.
To obtain the credentials for your AWS root account, follow the steps below:
This article shows how to connect to Amazon Athena data through the connection manager and execute queries. The CData JDBC Driver for Amazon Athena integrates Amazon Athena data with wizards and analytics in IDEs like Aqua Data Studio.