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)

沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南