Workgroup or Output Errors When Using Amazon Athena with Amazon QuickSight - Amazon QuickSight

Workgroup or Output Errors When Using Amazon Athena with Amazon QuickSight

To verify that workgroups are set up properly, check the following settings:

  • The Athena workgroup that's associated with the data source must exist.

    To fix this, you can return to the Athena data source settings and choose a different workgroup. For more information, see Setting Up Workgroups in the Athena User Guide.

    Another solution is to have the AWS account admin recreate the workgroup in the Athena console.

  • The Athena workgroup that's associated with the data source must be enabled.

    An AWS account admin needs to enable the workgroup in the Athena console. Open the Athena console by using this direct link: https://console.aws.amazon.com/athena/. Then choose the appropriate workgroup in the Workgroup panel and view its settings. Choose Enable workgroup.

  • You must have access to the Amazon S3 output location that's associated with the Athena workgroup.

    To grant Amazon QuickSight permissions to access the S3 output location, the Amazon QuickSight admin can edit Security & Permissions in the Manage QuickSight screen.

  • The Athena workgroup must have an associated S3 output location.

    An AWS account admin needs to associate an S3 bucket with the workgroup in the Athena console. Open the Athena console by using this direct link: https://console.aws.amazon.com/athena/. Then choose the appropriate workgroup in the Workgroup panel and view its settings. Set Query result location.