Need help troubleshooting Athena/ODBC error

Question

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.

AWS-User-8643885 · 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][1].

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][2].  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/
```

[1]: https://docs.aws.amazon.com/cli/latest/userguide/cli-configure-files.html#cli-configure-files-where
  [2]: https://developer.apple.com/library/archive/documentation/Security/Conceptual/AppSandboxDesignGuide/AppSandboxInDepth/AppSandboxInDepth.html

Need help troubleshooting Athena/ODBC error

Add your answer

Relevant content