- Newest
- Most votes
- Most comments
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/
Relevant content
- asked 2 years ago
- asked a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated 7 months ago