AWS managed MySQL connect as external schema in different account Amazon Redshift

0

Hi Is it possible to connect AWS managed MySQL to be connected as external schema in Amazon Redshift cluster, which is in different account. Please let know if there is any series of steps which needs to be followed.

asked 2 months ago29 views
1 Answer
0

Hi SumitJaiswal,

You can use the federated queries feature. Since the Amazon Redshift cluster is found in a different VPC, you may consider enabling the VPC peering.

Here's a link that lists all the major steps to get started https://docs.aws.amazon.com/redshift/latest/dg/getting-started-federated-mysql.html.

Thanks.

Ziad
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions