CLOUD LABS
Athena Federated Query with Amazon RDS
In this Cloud Lab, you’ll launch an Aurora MySQL instance in Amazon RDS and connect it with an EC2 instance to insert some records in our database. You’ll then use Amazon Athena to run federated queries and fetch data from our database.
intermediate
Certificate of Completion
Learning Objectives
Amazon Athena is an interactive query service that simplifies the process of querying data stored in different locations. The queries in Athena are based on metadata, which is data about the underlying data in a database. Athena supports federated queries, allowing it to work with distributed data sources. This is done by creating connectors in AWS Lambda.
In this Cloud Lab, you’ll provision an EC2 instance and an Aurora DB cluster with a MySQL-compatible database. You’ll also create a spill bucket in S3 and an IAM role. After that, you’ll deploy a connector using a Lambda application and then use your Aurora DB cluster as a data source in Athena. Finally, you’ll execute queries in a query editor provided by Athena to fetch data from your database.
After completing this Cloud Lab, you’ll be able to work with Amazon RDS and Athena to create database instances and execute federated queries using the query editor.
The following is the high-level architecture diagram of the infrastructure you’ll create in this Cloud Lab:
Before you start...
Try these optional labs before starting this lab.
Relevant Courses
Use the following content to review prerequisites or explore specific concepts in detail.
Trusted by 1.4 million developers working at companies including
Your method is simple, straight to the point and I can practice with it everywhere, even from my phone, that's something I have never had in other learning platforms.
I highly recommend Educative. The courses are well organized and easy to understand.
I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.
I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.
Your method is simple, straight to the point and I can practice with it everywhere, even from my phone, that's something I have never had in other learning platforms.
I highly recommend Educative. The courses are well organized and easy to understand.
I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.
Get access to Educative Cloud Labs