SHOW ICEBERG NAMESPACES

SHOW ICEBERG NAMESPACES lists namespaces referenced by registered Iceberg table mappings.

Description

The result contains catalog and namespace columns. Without a catalog qualifier, MatrixOne lists distinct namespaces referenced by table mappings in all registered catalogs in the current account. The statement does not discover unregistered namespaces from a remote REST catalog. LIKE and WHERE clauses are parsed for compatibility but are not supported at execution time.

Syntax

SHOW ICEBERG NAMESPACES
SHOW ICEBERG NAMESPACES FROM catalog_name
SHOW ICEBERG NAMESPACES IN CATALOG catalog_name

Examples

SHOW ICEBERG NAMESPACES;
SHOW ICEBERG NAMESPACES FROM prod_catalog;
SHOW ICEBERG NAMESPACES IN CATALOG prod_catalog;

See Also