amazon-s3amazon-athenaamazon-quicksight

Quicksight Athena - [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client

I am getting below error when i am trying to create New Dataset in Quicksight from Athena. I tried for "Table" and "view". It gives below error :

[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client.

com.amazonaws.services.s3.model.AmazonS3Exception: Access Denied (Service: Amazon S3; Status Code: 403;
 Error Code: AccessDenied; Request ID: 4X60ASZS5T2Q0A9C; S3 Extended Request ID:
(Path: s3://metadataitcfcontrol/) [Execution ID: a07d4718-ffae-40b7-9777-688399fbb56f]

Seeing the error message i understand problem is w.r.t access on S3 bucket, but how to fix it ? Thanks.

Solution

  • You can fix this by adding S3 bucket permission in the QuickSight console.

    Go to:

    Manage QuickSight -> Security & permissions -> Add or remove -> In S3 -> Details -> Select the bucket you want to query -> Update