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
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.
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.
S3 bucketand 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.
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
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:
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.
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.