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