SVV_EXTERNAL_SCHEMAS - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China.

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.

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