ICEBERG_NAMESPACES

Lists all the namespaces created using Iceberg in an Eon Mode database.

Lists details about the namespaces created using Iceberg in an Eon Mode database.

Column Name	Data Type	Description
`NAMESPACE_ID`	INTEGER	The ID number for the namespace.
`NAMESPACE_NAME`	VARCHAR(128)	The name of the namespace.
`CATALOG`	VARCHAR(128)	The name of the catalog used in the Iceberg namespace. The supported catalog types are filesystem, glue, hive, and rest.
`LOCATION`	VARCHAR(128)	The location of the Iceberg namespace.
`rest_auth`	VARCHAR(128)	The authentication method for the REST catalog which supports either bearerToken or OAuth2 authentication. Applicable only when CATALOG is rest.

Privileges

Only superuser has permissions. However, regular users can access Iceberg data if they have permissions on the underlying storage.

Examples

To list all the namespaces created using Iceberg in an Eon Mode database, run the following query:

=> SELECT * from v_catalog.iceberg_namespaces;
  namespace_id  | namespace_name    | catalog   | location                                  | rest_auth
-------------------+----------------+-----------------------------------------------------------------------
                | default_namespace |           |                                           |  
                | analytics         | glue      | s3://vertica-perpetual/user/iceberg_new   |
                | finance           | rest      | http://localhost:19120/iceberg/v1/main    | {"bearerToken":"token"} 
(3 rows)