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)

답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인