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
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/
Athena ODBC Connector for Power BIasked 8 months ago
Install Microsoft ODBC Driver for SQL Server on Elastic Beanstalkasked 6 months ago
Athena ODBC - Multiple Catalogsasked 5 months ago
[Announcement] Driver update required for Amazon Redshift ODBC Driver earlier than 1.4.10 on Apple macOSasked 2 years ago
PowerBI access to S3/AthenaAccepted Answerasked 4 years ago
Connecting to LightSail with MySQL Connector ODBCasked 3 years ago
Does Redshift windows ODBC driver supports DTC(Distributed Transaction Coordination)?asked 4 months ago
Getting connections error when updating Power BI table from AWS sourceasked 2 months ago
[AthenaJDBC](100131) An error has been thrown from the AWS SDK client. Connecting to Amazon Athena Data SourceAccepted Answerasked 7 months ago
Need help troubleshooting Athena/ODBC errorAccepted Answerasked 2 years ago