Unable to connect Quicksight to athena as it

Unable to read Athena database from AWS QuickSight . I’m trying to connect my quicksight to athena to get the queried Cloudfront logs stored in a database table. I’m unable to see the tables in quicksight . Please let me know what the issue is ? I tried giving all the permissions possible

Hi,

Athena is not a database, its a data explorer of different data source specially the S3.
You need to create connection with Athena and then create the dataset.
One think more create a database in Athena and try there the to data explore.

It’s simple method to create connection with Athena, you can re-check your permissions.

image

regards,
Naveed Ali

1 Like

Hi @Shreekar_Jayaram

Could you please check required permissions are granted as mentioned in the below article.

Hoping Cloudfront logs are also stored/available on the same account where QuickSight subscription is enabled.

Let us know if this is helpful.
And if it is, please help the community by marking the answer as a “Solution”.

Thanks
VInod

1 Like

Hi Shreekar, just to add one more point. Please make sure your Athena table are present in the same region when you’re searching using Quicksight.

1 Like