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.
AWS managed MySQL connect as external schema in different account Amazon Redshiftasked 2 months ago
Redshift is translating 'dbo' schema name in to 'public' schema name.asked 6 days ago
Redshift Disaster Recovery, attempting to restore tables to cluster in another account.asked 4 months ago
Redshift Data Share External Schemaasked 2 months ago
Redshift external schemaasked 6 months ago
Continuously replicate AWS Aurora MySQL to RedshiftAccepted Answerasked 3 years ago
AWS Glue Schema Registry and MSK Connect Integration for AVRO Schemaasked 7 months ago
Is it possible to have a Redshift Spectrum schema access multiple accounts data ?asked 8 months ago
Redshift serverless: error while trying to create an external tableasked 5 months ago
Amazon Schema Conversion Tool Connection error with Redshift as target databaseasked 3 months ago