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 their own data. For more information, see Visibility of data in system tables and views.
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, 4 indicates a schema for a local Amazon Redshift database, 5 indicates a schema for a remote Amazon Redshift database, 6 indicates a schema for a system table, 8 indicates a schema for remote MySQL databases, 9 indicates a schema for an Amazon Kinesis data stream, and 10 indicates an Amazon Managed Streaming for Apache Kafka data stream. |
| 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"}