Posted On: Dec 9, 2020
We announced general availability of Amazon Redshift federated query with support for Amazon RDS PostgreSQL and Amazon Aurora PostgreSQL earlier this year. With this feature, many customers have been able to combine live data from operational databases with the data in Amazon Redshift data warehouse and the data in Amazon S3 data lake environment in order to get unified analytics view across all the data in the enterprise. We now extend the federated query capability to Amazon RDS for MySQL and Amazon Aurora MySQL.
Amazon Redshift federated query allows you to incorporate live data from the transactional databases as part of your business intelligence (BI) and reporting applications to enable operational analytics. The intelligent optimizer in Amazon 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. Amazon Redshift complements subsequent execution of the query by leveraging its massively parallel processing capabilities for further speed up. Federated query also makes it easy to ingest data into Amazon 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.