We do not have special experience and knowledge using this technology.
And by the above document, it may work but it seems to have some restrictions.
Most PostgreSQL foreign-data wrappers should work with Greenplum Database. However, PostgreSQL foreign-data wrappers connect only through the Greenplum Database coordinator by default and do not access the Greenplum Database segment instances directly.
Hello,
Do you mean about this GreenPlum database? https://docs.vmware.com/en/VMware-Greenplum/7/greenplum-database/admin_guide-external-g-foreign.html
We do not have special experience and knowledge using this technology. And by the above document, it may work but it seems to have some restrictions.