Posted On: Dec 3, 2019
The in-preview HAQM Redshift Federated Query feature allows you to query and analyze data across operational databases, data warehouses, and data lakes. With Federated Query, you can now integrate queries on live data in HAQM RDS for PostgreSQL and HAQM Aurora PostgreSQL with queries across your HAQM Redshift and HAQM S3 environments.
Federated Query allows you to incorporate live data as part of your business intelligence (BI) and reporting applications. The intelligent optimizer in Redshift pushes down and distributes a portion of the computation directly into the remote operational databases to speed up 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, applying transformations on the fly, and loading data into the target tables without requiring complex ETL pipelines.
The Federated Query feature is available to all Redshift customers for preview. To get started and learn more, visit the documentation. Refer to the AWS Region Table for HAQM Redshift availability.