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:
