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

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.