- 最新
- 投票最多
- 评论最多
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/
相关内容
- AWS 官方已更新 3 年前
- AWS 官方已更新 2 年前