Important Note: You will create AWS resources during the workshop which will incur cost in your AWS account. It is recommended to clean-up the resources as soon as you finish the workshop to minimize the cost.
Amazon Redshift Federated Query with RDS PostgreSQL
Amazon Redshift federated query allows query and analysis of data across operational databases, data warehouses, and data lakes. Federated Query integrates queries from Amazon Redshift on live data in external databases with queries across the Amazon Redshift and Amazon S3 environments. Federated queries can work with external databases in Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL compatibility.
In this workshop, you configure federated query between Redshift and Amazon Aurora with PostgreSQL compatibility.
The following diagram shows the scenario you are going to build. Start the workshop