What are the performance considerations while using the Redshift Federated Queries to access and query data present in Amazon Aurora RDS PostgreSQL database? The Redshift Zero ETL feature is still in preview for PostgreSQL and hence exploring the feature of Redshift Federated Query.

Looking for recommendations around volume of data, number of tables, etc. that should be considered while using this feature.