Carlos Aguni

Highly motivated self-taught IT analyst. Always learning and ready to explore new skills. An eternal apprentice.


DBeaver AWS Credentials

21 Jun 2023 »

https://stackoverflow.com/questions/69991535/failure-querying-aws-athena-from-dbeaver-using-iam-profiles-ephemeral-credenti

~/.aws/config

[default]
aws_access_key_id=AKIA2B4T4
aws_secret_access_key=cFOsH4T3eabVlJ
region=sa-east-1

[test]
aws_access_key_id=ASIA2B4T4G
aws_secret_access_key=DvZaOey2++v/lzZ
aws_session_token=IQoJb3JpZ2luX2VjEFo

AwsCredentialsProviderArguments: <your profile credentials> AwsCredentialsProviderClass : com.simba.athena.amazonaws.auth.profile.ProfileCredentialsProvider

aws sts assume-role --role-arn arn:aws:iam::org-id:role/athena-s3-from-assume-ecs-course --role-session-name test