search

kovihq / sqltools-athena-driver

AWS Athena Driver for VSCode Plugin SQLTools
MIT License
5 stars 11 forks source link

Error opening connection Missing credentials in config #33

Open amitkbhola opened 1 year ago

amitkbhola commented 1 year ago

Athena Connection not working. Getting following error ERROR: Error opening connection Missing credentials in config, if using AWS_CONFIG_FILE, set AWS_SDK_LOAD_CONFIG=1, {"code":-32001,"data":{"driver":"driver.athena","driverOptions":{}}}

I did validate the default AWS connection profile works and Athena primary workgroup is setup correctly. If the AWS_SDK_LOAD_CONFIG=1 need to be setup where do I need to include this parameter. Please help with the issue

image

jordaneliastam commented 1 year ago

samesies...

mdub commented 4 months ago

Yeah, I get the same error.

FWIW I'm using a ~/.aws/credentials entry that looks like this:

[xyz-staging--admin]
credential_process = aws-creds get 497499903228 admin

The error logs says:

[1708834995031] INFO  (ls): Connection instance created for xyz-staging-mw.
    ns: "conn-manager"
[1708834995038] ERROR (ls): Connecting error: {"code":-32001,"data":{"driver":"driver.athena","driverOptions":{}},"name":"CredentialsError"}
    ns: "conn-manager"
[1708834995038] ERROR (ls): Open connection error
    ns: "conn-manager"
[1708834995038] ERROR (ext): ERROR: Error opening connection Missing credentials in config, if using AWS_CONFIG_FILE, set AWS_SDK_LOAD_CONFIG=1, {"code":-32001,"data":{"driver":"driver.athena","driverOptions":{}}}
    ns: "error-handler"