Query Encrypted Amazon S3 Data with Amazon Athena
- Stay within resource usage requirements.
- Do not engage in or encourage activity that is illegal.
- Do not engage in cryptocurrency mining.
- View the detailed terms of use here
The hands-on lab is part of these learning paths
Ready for the real environment experience?
Description
Amazon Simple Storage Service (S3) is a web service from AWS that enables you to store data at scale in the cloud. Amazon S3 supports encrypting data at rest. Amazon Athena is a query service that integrates with Amazon S3 allowing you to easily access and analyze your data.
By combining Amazon S3 and Amazon Athena you can achieve end-to-end security:
- Data is stored encrypted in Amazon S3 (at rest)
- All communications within AWS are encrypted (in transit)
- Amazon Athena query results are encrypted (at rest)
In this hands-on lab, you will upload data files to Amazon S3. Configure one of the files to be stored encrypted. And you will use Amazon Athena to query both files.
Learning Objectives
Upon completion of this lab you will be able to:
- Encrypt data on S3
- Define a schema in order to create a database and table in Amazon Athena
- Perform basic queries in Athena
- Encrypt the query results
Prerequisites
Familiarity with the following will be beneficial but is not required:
- Amazon S3
- Amazon Athena
The following courses can be used to fulfill the prerequisites:
Lab Environment
After completing the lab instructions the environment should look similar to:
Updates
April 14th, 2022 - Updated the instructions and screenshots to reflect the latest UI
January 21st, 2022 - Updated the instructions and screenshots to reflect the latest UI
December 21, 2021 - Updated grammar.
October 5, 2021 - Added a note about changes to the interface and how to access the previous interface.
January 10th, 2019 - Added a validation Lab Step to check the work you perform in the Lab
Greg has been a consistent high performer for pioneering technologies in the wireless web industries with an illustrious career that is a testament to his breadth of knowledge. Dabbling with MS Azure, at Cloud Academy, Greg really thrives on evangelizing the benefits of Amazon Web Services. A dedicated and passionate professional who learns new and emerging technologies quickly, Greg always ensures the highest quality and caliber of everything he produces.