Aurora MySQL doesn't support federated storage engine. To consolidate data from multiple Aurora MySQL clusters, setup EC2 instance or Lambda, then fetch data from source clusters, and insert into target cluster.
As alternative, Amazon Athena federated query might be the option.
Here's an entire blog documentation for your particular use-case of federated querying.
Switch Reserved Instance from Aurora to mySQLasked 2 years ago
Linked server connection from on-prem SQL Server to RDS MySQL?asked 4 days ago
Need help in upgrading the aurora MYSQL 5.7 to MYSQL 8 [URGENT]asked 9 months ago
Migrate RDS MySQL 8.0.28 to Aurora MySQLasked 2 months ago
Aurora v2.10.2 - MySQL Server Has Gone Awayasked 21 days ago
AWS Aurora MYSQL enabling Federated Serverasked 14 days ago
TLS 1.2 + Aurora Serverless MySqlAccepted Answerasked 2 years ago
Next Aurora MySQL version release?asked 4 months ago
Lost connection to MySQL server when scaling RDS Aurora Clusterasked 20 hours ago
Aurora Serverless MySQL - Supported OptionsAccepted Answerasked 2 years ago