Connecting Users to AWS Athena and AWS Lake Formation via Tableau Desktop using the Simba Athena JDBC Driver and Okta as Identity Provider

0

Hello, due to the following Step by Step Guide provided by the official AWS Athena user-guide (Link at the End of the question), it should be possible to connect Tableau Desktop to Athena and Lake Formation via the Simba Athena JDBC Driver using Okta as Idp. The challenge that I am facing right now, is although i followed each step as documented in the Athena user-guide i can not make the connection work. The error message that i recieve whenever i try to connect Tableau Desktop states:

[Simba]AthenaJDBC An error has been thrown from the AWS Athena client. The security token included in the request is invalid. [Execution ID not available] Invalid Username or Password.

My athena.properties file to configure the driver on the Tableau via connection string URL looks as follows (User Name and Password are masked):

jdbc:awsathena://AwsRegion=eu-central-1; 
S3OutputLocation=s3://athena-query-results;
AwsCredentialsProviderClass=com.simba.athena.iamsupport.plugin.OktaCredentialsProvider;
idp_host=1234.okta.com;
User=*****.*****@example.com;
Password=******************;
app_id=****************************;
ssl_insecure=true;
okta_mfa_type=oktaverifywithpush;
LakeFormationEnabled=true;

The configuration settings used in here are from the official Simba Athena JDBC driver documentation (Version: 2.0.31).

Furthermore i assigned the required permissions for my users and groups inside Lake Formation as stated in the Step by Step guide linked below.

Right now I am not able to point out why I am not able to make the connection work. So I would be very greatful for any support / idea to find a solution on that topic.

Best regards

Link: https://docs.aws.amazon.com/athena/latest/ug/security-athena-lake-formation-jdbc-okta-tutorial.html#security-athena-lake-formation-jdbc-okta-tutorial-step-1-create-an-okta-account)

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