Redshift external schema does not work with Aurora PostgreSQL 14.x or 15.x

Hello,

I have a Redshift database as well as multiple Aurora PostgreSQL clusters. My Aurora PSQL clusters use varying versions of the PSQL engine:

• 15.4
• 14.9
• 14.6
• 13.12
• 13.8

My goal is to create an external schema for each of these Aurora PostgreSQL clusters within my Redshift database so that I can query them from Redshift.

I have been able to successfully do this for the Aurora PostgreSQL clusters that use engine versions 13.12 and 13.8, however I have NOT been able to do this for any of the other versions (14.6, 14.9, 15.4). For these clusters, the external schema shows zero tables.

Is it possible that external schemas for Aurora PostgreSQL clusters that engine version 14.x or higher are not supported by Redshift?