By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre: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
Amazon AthenaAnalyticsSecurity, Identity, & Compliance
Language
English
repost_user_1342
asked a year ago491 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.

profile picture
jhashimoto
answered a year ago
  • repost_user_1342
    a year ago

    Let me get back to you with the update if it worked. Thanks!

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
Corvus_L
answered a year 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.

Guidelines for Answering Questions

Relevant content