Unable to retrieve Athena workgroups

Question & Answer
,
1

I am trying to connect an Athena database to my quicksight. I keep getting this error saying " Unable to retrieve Athena workgroups. Wait a few moments and click here to try again."

I checked the Security and Permissions area and both Athena and the relevant S3 buckets have access in Quicksight. That seems to be the only recommended fix I can find online but it did not work for me. FYI I am not the root user on this account.

Screen Shot 2022-12-09 at 4.01.53 PM

2

Have you changed any permissions in the workgroup itself?

3

I didn’t change any permissions in the workgroup. This is the specific error message I get.

Screen Shot 2022-12-09 at 4.26.29 PM

4

I got it to work. I followed the directions at this link and attached a new IAM policy to the Quicksight role I was using. Thanks Max.

1 Like
5

image

I am getting a similar error. I added full athena, s3 access to the aws-quicksight-s3-consumers-role-v0. Still it throws the same error. Can you help me with this ?

6

Fixed by going to:

  • Manage Quicksight settings
  • Security & Permissions
  • Scroll down to IAM Policy Assignments
  • Choose Add New Assignment
  • Provide Name like AWSAthenaWorkgroups, then click Next
  • Type/Find AWSQuicksightAthenaAccess then click Next
  • Assign to all users and groups OR select a specific user or group, then click Next
  • Click Save and Enable