CLOUD LABS
Amazon Redshift Federated Query with Aurora MySQL
In this Cloud Lab, you’ll create an Aurora MySQL database and an Amazon Redshift cluster and insert some records in both databases. After that, you’ll execute a federated query that will bring the data from both databases.
intermediate
Certificate of Completion
Learning Objectives
Amazon Redshift is a fully managed data warehouse service that facilitates quick querying and analysis of extensive datasets using SQL. Amazon Redshift supports federated queries, allowing it to work with distributed data sources.
In this Cloud Lab, you’ll provision an EC2 instance and an Aurora DB cluster with a MySQL-compatible database. You’ll create a secret for the Aurora database that will establish a connection to the MySQL database. After that, you’ll create an IAM role to allow Redshift to access the Secrets Manager and launch a Redshift cluster. Finally, you’ll create an external schema of the Aurora database and execute a federated query on both databases.
After completing this Cloud Lab, you’ll have sufficient knowledge of working with the Aurora and Redshift databases and executing federated queries using the query editor.
The following is the high-level architecture diagram of the infrastructure you’ll create in this Cloud Lab:
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