data-engineer video for a company uses Amazon Redshift for its data warehouse and has operational data stored in Amazon Aurora with PostgreSQL compatibility.
A company uses Amazon Redshift for its data warehouse and has operational data stored in Amazon Aurora with PostgreSQL compatibility. They need to run real-time analytics without moving data into Redshift. How can the company MOST efficiently query the data in both Redshift and Aurora?