Unable to select the database when creating dataset for Athena

Q&A
, ,
1

image
image842×643 26.1 KB

I am unable to select the database when creating dataset for Athena. I have given the required permissions to the quicksight role for s3, glue, athena etc. I have also given permission to the quicksight role on database and table in lakeformation.
Can’t think why i still can’t select my database. Kindly suggest.

2

There are a few things you can check if you are unable to select the database when creating a dataset for Athena in Amazon Quick Sight:

  1. Check the IAM permissions: Ensure that the Quick Sight user/role has the necessary permissions to access the Athena service and the specific database/tables you want to use. The permissions should include:

    • athena:GetDatabase
    • athena:GetTable
    • athena:StartQueryExecution
    • athena:GetQueryExecution
    • athena:GetQueryResults
    • glue:GetDatabase
    • glue:GetTable

  2. Check the database/table visibility: Verify that the database and tables you are trying to access are visible and accessible to the Quick Sight user/role. You can try the following:

    • Check if the database and tables are listed in the Athena console.
    • Ensure that the database and tables are not hidden or restricted in any way.
    • Verify that the Quick Sight user/role has the necessary permissions in AWS Lake Formation (if applicable) to access the database and tables.

  3. Check the data source connection settings: In the Quick Sight data source settings, ensure that the connection to Athena is properly configured. Double-check the following:

    • The AWS Region is correct.
    • The IAM role or user credentials are valid and have the required permissions.
    • The database name is spelled correctly and matches the actual database name.

  4. Check for VPC networking issues: If your Athena database is located in a VPC, make sure that the Quick Sight service has the necessary network access to connect to the VPC and the Athena service. Check the VPC settings, security groups, and any relevant network configurations.

  5. Verify the Athena workgroup settings: Ensure that the Athena workgroup used by Quick Sight is properly configured and the Quick Sight user/role has the necessary permissions to access the workgroup.

  6. Troubleshoot with AWS Support: If you have exhausted the above steps and are still unable to select the database, consider reaching out to AWS Support for further assistance. They can help you investigate the issue and provide guidance based on your specific setup and configuration.

Start by thoroughly reviewing the IAM permissions and the database/table visibility, as these are the most common reasons for the inability to select the database in Quick Sight. If you’re still facing issues, the AWS Support team can help you identify and resolve the underlying problem.

3

Hi @ChrisHeath62,
It’s been awhile since we last heard from you. Were you able to go through murili’s suggestions and did it work for your issue? If so, feel free to share with the community what helped with your scenario.

If we do not hear back from you within the next 3 business days, I’ll go ahead and archive this.

Thank you!

4

Hi @ChrisHeath62,
Since we haven’t heard back, I’ll go ahead and mark this as solved. If you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information.

Thank you!