Redshift cross AWS account connection recommended?

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

Topics

Analytics

Tags

Amazon Redshift

Language

English

asked a year ago492 views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

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

Don_D

answered a year ago

Relevant content

Are ec2 instance types unique per account?
lzap
asked 2 years ago
Cross account connection between two AWS accounts on same zone
Shilpa
asked a year ago
DRS cross AZ and cross regions using same account
Matias Silvero
asked 6 months ago
How to connect two VPCs which have the same CIDR Blocks in the same account but two different regions ?
Mahmoud
asked a month ago
How do I install AWS Private CA root and subordinate CAs in different accounts or Regions?
AWS OFFICIALUpdated 4 months ago
What are the differences between AWS accounts and AWS India accounts?
AWS OFFICIALUpdated a year ago
How do I create a cross-account Lambda function to access Amazon Redshift in a different account?
AWS OFFICIALUpdated 5 months ago
How do I transfer an Elastic IP address between AWS accounts in the same Region?
AWS OFFICIALUpdated a year ago
How to setup cross-account Redshift auto copy
EXPERT
RiteshKSinha
published 7 months ago
A step-by-step guide to cross-account and cross-region events with EventBridge
EXPERT
Antonio_Lagrotteria
published a year ago