I just spent about 30 minutes working out how to connect to DBeaver using my normal AWS credentials file / default credentials.
Thankfully I stumbled across this GitHub and it worked like a charm: https://github.com/dbeaver/dbeaver/issues/3918#issuecomment-511484596.
Here are the relevant notes (slightly modified for easier understanding):
- Do your normal AWS login process to refresh your credentials (in our case, we use okta + gimme_aws_creds for this).
- Go to driver properties on your DBeaver Athena connection and set:
AwsCredentialsProviderClass
tocom.simba.athena.amazonaws.auth.profile.ProfileCredentialsProvider
AwsCredentialsProviderArguments
equal to the name of the profile you want to use (see ~/.aws/config to see which profiles you have) – we use “default”.
- Test Connection and it should work.