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 Resposta
0
Resposta aceita

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

respondido há 2 anos

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas