By using AWS re:Post, you agree to the Terms of Use

Need help troubleshooting Athena/ODBC error

0

I have a customer who is trying to use ODBC to connect to Athena. They have followed this documentation for "Configuring ODBC Connections on a NonWindows Machine" setup: https://s3.amazonaws.com/athena-downloads/drivers/ODBC/SimbaAthenaODBC_1.0.5/Simba+Athena+ODBC+Install+and+Configuration+Guide.pdf

Connectivity works fine on macOS when AuthenticationType=IAM credentials.

Have issues getting it to work with AuthenticationType=IAM Profile as suggested here https://www.simba.com/products/Athena/doc/ODBC_InstallGuide/mac/content/odbc/ath/configuring/authenticating/iamprofile.htm

I have re-produced Customer setup. The following is the error that I get while using AuthenticationType=IAM Profile

08S01
[Simba] [DriverIAMSupport] (8600) Connection Error: No AWS profile found: default

Has anyone come across this error ? Kindly help, thanks.

asked 2 years ago247 views
1 Answer
0
Accepted Answer

This error occurs when the profile set in the ODBC AwsProfile keyword is missing from .aws/credentials. In this particular case you've either set AwsProfile=default or didn't specify a profile and its its looking for the profile named default in the credentials file.

You should configure the credentials in the in .aws/ credentials files according the cli documentation here.

then setup or odbc.ini similar to:

[ODBC Data Sources]
Athena=Simba Athena ODBC Driver
[Athena]
Driver=/Library/simba/athenaodbc/lib/libathenaodbc_sbu.dylib
AwsRegion=us-west-2
S3OutputLocation=s3://query-results-bucket/testfolder-1
AuthenticationType=IAM Profile
AwsProfile=someprofilename

UPDATE

While the information above is correct, in this particular instance the issue was with Excel and the MacOS Application Sandboxes. Microsoft Excel is Sandboxed and is unable to read the path ~/.aws/credentials to retrieve the profile credentials. A work around is to create a .aws directory inside the Excel sandbox directory and then hard link the credentials file. This will work around the issue and still use the original credentials file.

mkdir  ~/Library/Containers/com.microsoft.Excel/Data/.aws
ln ~/.aws/credentials  ~/Library/Containers/com.microsoft.Excel/Data/.aws/
answered 2 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.

Guidelines for Answering Questions