Amazon Redshift
Database Developer Guide (API Version 2012-12-01)


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 integer The type of the external catalog for the external schema; 1 indicates a data catalog, 2 indicates a Hive metastore.
schemaname text External schema name.
esowner text User ID of the external schema owner.
external_db text External database name.
esoptions text External schema options.


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"}

On this page: