Connect Athena to QuickSight

8.1 Connect Athena to QuickSight

  1. Set up IAM Role.
  • From the QuickSight home page, select Manage QuickSight, in the upper right corner Quicksight
  • Select Security & Permission Quicksight
  • Select Manage Quicksight
  • We see the role name, go to the Roles section of IAM, find that role name Quicksight
  • Attach Policy for the role: AmazonAthenaFullAccess, AmazonS3FullAccess,AWSGlueServiceRole,AWSQuicksightAthenaAccess Quicksight Quicksight Quicksight
  1. Go to Amazon QuickSight → Manage data
  2. Select New dataset → Athena Quicksight Quicksight Quicksight Quicksight
  3. Name and select Athena workgroup Quicksight
  4. Select database sales_analysis_db, table sales_data_processed
  5. Import data or use SPICE mode to speed up Quicksight Quicksight