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

Question

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.

Answer

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.

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

Contenuto pertinente