Amazon Redshift now supports cross-Region queries for your data lake

Amazon Redshift Cross-Region Queries for Data Lake Tables

Amazon Redshift now supports querying Amazon S3 data lake tables located in a different AWS Region. With enhanced VPC routing, data lake query traffic between Amazon S3 and Amazon Redshift stays within your own VPC. Both capabilities are powered by the integrated data lake query engine that runs directly on the compute of RG provisioned and Serverless clusters.

What to do

• Use Amazon Redshift to query S3 data in another Region directly, without copying or replicating it.
• Run global analytics and consolidate reporting across Regions.
• Query data that must remain in a specific Region for residency requirements.

Cross-Region queries incur standard data transfer charges. Data moving between Amazon S3 and Amazon Redshift flows entirely over your VPC when you use enhanced VPC routing, never over public networks. This feature benefits regulated industries such as financial services, healthcare, and government by keeping data lake queries within the network boundaries their compliance requirements demand.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.