- 최신
- 최다 투표
- 가장 많은 댓글
Hello,
Looking at the error message, it seems there was a lack of permission.
Please refer the below mentioned documents [+] https://repost.aws/knowledge-center/quicksight-access-denied-athena-data [+] https://community.amazonquicksight.com/t/why-cant-i-edit-cid-datasets/20046
This error generally occurs when there are missing permissions in Lake Formation. If you are querying data with Amazon Athena, you can use AWS Lake Formation to simplify how you secure and connect to your data from Amazon QuickSight.
Please follow below steps to grant SELECT permissions on database ‘your_database_name’ and table ‘your_table_name’ to the Quicksight user/group:
- Sign in to the AWS Lake Formation console as the data lake administrator.
- Choose Database.
- Select 'Your_database_name'
- From the Actions drop-down menu, choose View permissions. You will see a list of principals with associated permissions for each resource type.
- Choose Grant.
- Select the drop down menu for ‘SAML users and groups’.
- Add Quicksight user arn.
- Select tables.
- For Table permissions, select SELECT.
- Choose Grant.
- Following the same steps, you will also need to do the same for the QuickSight service role "aws-quicksight-service-role-v0". Choose IAM users and roles for this.
After granting permissions, please check if you are able to list databases while creating Athena dataset.
Please raise a support case in case this issue persists.