Unable to connect to Athena Data Source through STSAssumeRole

0

[Simba]AthenaJDBC An error has been thrown from the AWS SDK client. Unable to load AWS credentials from any provider in the chain: [EnvironmentVariableCredentialsProvider: Unable to load AWS credentials from environment variables (AWS_ACCESS_KEY_ID (or AWS_ACCESS_KEY) and AWS_SECRET_KEY (or AWS_SECRET_ACCESS_KEY)), SystemPropertiesCredentialsProvider: Unable to load AWS credentials from Java system properties (aws.accessKeyId and aws.secretKey), WebIdentityTokenCredentialsProvider: You must specify a value for roleArn and roleSessionName, com.simba.athena.amazonaws.auth.profile.ProfileCredentialsProvider@34305b71: profile file cannot be null, com.simba.athena.amazonaws.auth.EC2ContainerCredentialsProviderWrapper@2c3dc059: Unauthorized (Service: null; Status Code: 401; Error Code: null; Request ID: null; Proxy: null)] [Execution ID not available]

I'm getting the above error while trying to connect to the athena data source while using stsassumerole for authentication. JDBC string is in the following format: jdbc:awsathena://AwsRegion=us-east-1;AwsCredentialsProviderClass=com.simba.athena.amazonaws.auth.STSAssumeRoleSessionCredentialsProvider;AwsCredentialsProviderArguments=temp_athena_role,sessionName;S3OutputLocation=s3://temp_s3_bucket_path;workgroup=temp;LogLevel=3;LogPath=temp_path

I've checked and STS policy is attached at both the roles and resource/principal parameters are also filled correctly. What can be the possible root causes for this error?

yashd
gefragt vor 4 Monaten424 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen