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
asked 3 months ago421 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions