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

Don_D · 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