Amazon Athena allows you to query data stored in S3 using SQL. This Amazon Athena playground lab provides you with an Athena sandbox for you to query COVID-19 data provided by the AWS COVID-19 data lake. The playground configures AWS Glue tables that are backed by the AWS COVID-19 data lake which is hosted on Amazon S3. You can query the Glue tables with Athena using SQL. Links are also provided to the AWS blog announcing the AWS COVID-19 data lake (including sample Athena queries to get you started), and the AWS QuickSight dashboard providing recent COVID-19 data visualizations.
The playground is a safe and secure sandbox environment for you to explore your own ideas, follow along with Cloud Academy courses, or answer your own questions all without the need to install any software on your local machine. The extended duration of this playground provides you with ample time to play to your heart's content. Have fun in the playground!
This lab playground is intended for:
There are no prerequisites for this lab playground.
April 27th, 2023 - Updated screenshots and instructions to reflect latest UI
February 16th, 2021 - Updated the lab with a supplemental query due to the AWS-provided query now returning no results, and increased the per query data scan limit
October 30th, 2020 - Changed the
country_code serialization to use a CSV (org.apache.hadoop.hive.serde2.OpenCSVSerde) algorithm rather than the lazy serialization algorithm configured in AWS' template to properly read country names with commas.
Logan has been involved in software development and research since 2007 and has been in the cloud since 2012. He is an AWS Certified DevOps Engineer - Professional, AWS Certified Solutions Architect - Professional, Microsoft Certified Azure Solutions Architect Expert, MCSE: Cloud Platform and Infrastructure, Google Cloud Certified Associate Cloud Engineer, Certified Kubernetes Security Specialist (CKS), Certified Kubernetes Administrator (CKA), Certified Kubernetes Application Developer (CKAD), and Certified OpenStack Administrator (COA). He earned his Ph.D. studying design automation and enjoys all things tech.