Use SVV_EXTERNAL_DATABASES to view details for external databases.
SVV_EXTERNAL_DATABASES 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 |
|---|---|---|
| eskind | integer | The type of the external catalog for the database;
1 indicates a data catalog,
2 indicates a Hive metastore. |
| esoptions | text | Details of the catalog where the database resides. |
| databasename | text | The name of the database in the external catalog. |
| location | text | The location of the database. |
| parameters | text | Database parameters. |
