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.
CodePudding user response:
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