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.
9 Tasks
intermediate
1hr 30m
Certificate of Completion
Desktop OnlyDevice is not compatible.
No Setup Required
Amazon Web Services
Learning Objectives
Understanding of Amazon Aurora DB and its core concepts
Working knowledge of creating an external schema of MySQL using the query editor
Hands-on experience setting up a Redshift cluster
The ability to execute a federated query using Amazon Redshift
Technologies
AWS
Redshift
Aurora
Aurora MySQL
Federated Query
EC2
Desktop Only
No Setup Required
Amazon Web Services
Labs Rules Apply
Stay within resource usage requirements.
Do not engage in cryptocurrency mining.
Do not engage in or encourage activity that is illegal.