Posted On: Apr 16, 2020
Amazon Redshift enables you to query data across your operational databases, your data warehouse, and your data lake. With Amazon Redshift Federated Query, you can query live data in Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL and integrate it with the data in your Amazon Redshift and Amazon S3 environments.
Amazon Redshift Federated Query allows you to incorporate live data as part of your business intelligence (BI) and reporting applications. The intelligent optimizer in Redshift uses statistics from the operational database to determine the most efficient way to execute a federated query. Redshift pushes down and distributes a portion of the query directly into the remote operational databases to speed up query performance by reducing data moved over the network. Redshift complements query execution, as needed, with its own massively parallel processing capabilities. Federated Query also makes it easy to ingest data into Redshift by letting you query operational databases directly, apply transformations on the fly, and load data into the target tables without requiring complex ETL pipelines.
Federated Query is now available with Amazon Redshift cluster version 1.0.14677 or later. To learn more about federated query, visit the documentation and the blogs Federated query use cases, Getting started with federated query using AWS CloudFormation. Refer to the AWS Region Table for Amazon Redshift availability.