Redshift Enhanced VPC Routing and Cross-Region COPY and UNLOAD commands

0

Hi everyone,

Our Redshift cluster is contained within a VPC and has enhanced VPC routing enabled. We have to unload some data to a bucket in a different region. We've recently discovered that we cannot issue COPY and UNLOAD commands with the REGION keyword that specifies that the S3 location is in a different region. It doesn't throw the usual IAM permissions error, but just hangs indefinitely doing nothing.

Has anyone encountered this? I understand that anything in a VPC has unique networking and routing requirements. What needs to be done to allow Redshift in a VPC to access a specific bucket in another region?

Thanks!

1 Answer
0
Accepted Answer

I've figured it out. The solution is to enable a VPC endpoint to the bucket. See here https://docs.aws.amazon.com/redshift/latest/mgmt/enhanced-vpc-routing.html

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions