Posted On: Apr 16, 2020
HAQM Redshift enables you to query data across your operational databases, your data warehouse, and your data lake. With HAQM Redshift Federated Query, you can query live data in HAQM RDS for PostgreSQL and HAQM Aurora PostgreSQL and integrate it with the data in your HAQM Redshift and HAQM S3 environments.
HAQM 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 HAQM 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 HAQM Redshift availability.