Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

IAM Role/profile support with Athena ODBC Connector

0

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.

Topics
AnalyticsSecurity, Identity, & Compliance
Tags
AnalyticsAmazon AthenaSecurity, Identity, & Compliance
Language
English
asked 3 years ago1.3K views
2 Answers
1

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.

answered 3 years ago
0

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

AWS
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content