Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

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!

Topics
AnalyticsNetworking & Content DeliveryStorage
Tags
Amazon VPCAmazon RedshiftAmazon Simple Storage Service
Language
English

asked 4 years ago702 views

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 4 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.

Relevant content