SVV_EXTERNAL_SCHEMAS

Use SVV_EXTERNAL_SCHEMAS to view information about external schemas. For more information, see CREATE EXTERNAL SCHEMA.

SVV_EXTERNAL_SCHEMAS is visible to all users. Superusers can see all rows; regular users can see only metadata to which they have access.

Table columns

Column name	Data type	Description
esoid	oid	External schema ID.
eskind	smallint	The type of the external catalog for the external schema: 1 indicates a data catalog, 2 indicates a Hive metastore, 3 indicates a federated query to Aurora PostgreSQL or Amazon RDS PostgreSQL, and 4 indicates a schema for another Amazon Redshift database.
schemaname	name	External schema name.
esowner	integer	User ID of the external schema owner.
databasename	text	External database name.
esoptions	text	External schema options.

Example

The following example shows details for external schemas.

select * from svv_external_schemas;

esoid  | eskind | schemaname | esowner | databasename | esoptions                                                   
-------+--------+------------+---------+--------------+-------------------------------------------------------------
100133 |      1 | spectrum   |     100 | redshift     | {"IAM_ROLE":"arn:aws:iam::123456789012:role/mySpectrumRole"}