How to list all external Schemas in Redshift database

svv_external_schemas system catalog view provides list of all external schemas in your Redshift database.

SELECT * FROM svv_external_schemas;

See also  How to find the size of a Redshift database