Discovering batch insights with Amazon QuickSight

Now that you have queried your data with Athena, it is time to analyze it using Amazon QuickSight.

  • Go to the AWS Management Console, select Services, and then choose QuickSight.

  • Before importing your data and creating visualizations, you need to make sure that certain permissions are in order. Change the region in the top right corner to US East (N. Virginia) as this is the only region that you can currently edit QuickSight settings in.

  • In the top right, next to where you just changed the region, select your user and then choose Manage QuickSight from the drop down.

  • On the left-hand panel, select Security & permissions. You need to allow QuickSight access to certain AWS services.

  • Click Add or remove to edit the services QuickSight has permissions to access.

  • Make sure to uncheck and then recheck the box for Athena, which will then prompt you to allow permissions for S3.

You should see something similar to this when you uncheck and recheck the Athena box. Hit Next to do S3 bucket selection.

  • Find your S3 bucket and make sure the box for your S3 bucket is checked. Also make sure to allow Write permission for Athena Workgroup

  • Make sure to hit Update to save your permissions

  • After ensuring the correct permissions, go back to the region you were working in before if it is not US East 1, since this is the region you have been working in the entire lab and will be where your Glue Data Catalog and your Athena table view are. This lab uses us-east-1 as a guideline but you may have done this in another region that supports all the services.

  • Once you are on the QuickSight dashboard, select New analysis in the top left corner.

  • Select New dataset and then click Athena as the data source.

  • Enter a name for your data source. This lab will use peculiar-data-source as the name. Leave the workgroup as primary. Click Create data source.

  • Next, it says to choose your table. Select the Glue Data Catalog you created previously. This lab uses the name peculiar-data-catalog.

  • Then, select the only table in the Glue Data Catalog. This lab uses the name peculiar_wizards_data_lake, but yours might be different. It should look similar to this:

  • Hit Select.

  • Next, you can optionally choose to Import to SPICE for quicker analytics if you want to do so. SPICE is QuickSights in-memory calculation engine that improves the performance of importing data and creating visualizations. For the purpose of this lab, you can just select Directly query your data.

  • Finally, select Visualize.

If you are running into a permissions error, similar to something like “An error has been thrown from the AWS Athena client. Access Denied (Service: Amazon S3)”, then go back to the beginning of this section and make sure you are including your newest S3 bucket by unchecking and then rechecking the box for Athena and allowing permission to your S3 bucket as well as the Athena workgroup.