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 Risposta
0
Risposta accettata

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

con risposta 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande