Redshift cross AWS account connection recommended?

Question

Hello AWS Experts,
We are having two different AWS account in the same  region. For instance Account_1 and Account_2. Account_1 EC2 has Talend installed and Account_2 has Redshift. We need to fetch Redshift(Account_2) data directly from Account_1. Is cross account connection for fetching data is recommended?

Can anyone please help me here? Kindly give me the URL also if you have.
Appreciate your help!

Thanks,
RN

Answer

If you are running RA3 node type, then using Redshift-managed VPC endpoints is what you should take a look at.  It supports cross-account access as well.

https://docs.aws.amazon.com/redshift/latest/mgmt/managing-cluster-cross-vpc.html

Redshift cross AWS account connection recommended?

Relevanter Inhalt