SHOW ICEBERG CATALOGS

Iceberg documentation index: Iceberg Documentation Overview.

SHOW ICEBERG CATALOGS lists the Apache Iceberg REST catalogs that have been registered in the current MatrixOne account, so you can see which external catalogs are available.

Description

SHOW ICEBERG CATALOGS returns the Iceberg catalogs registered with CREATE ICEBERG CATALOG for the current account. The result includes each catalog’s name and connection details.

Result set

Column

Description

name

Catalog name.

type

Catalog type, for example rest.

uri

REST endpoint of the catalog.

warehouse

Warehouse location used by the catalog.

auth_mode

Authentication mode, for example none.

version

Catalog version, incremented when ALTER ICEBERG CATALOG changes its configuration.

Usage notes

Use SHOW ICEBERG CATALOGS to inspect the catalogs and connection details registered for the current account. The statement requires the appropriate privilege; an unauthorized user receives do not have privilege to execute the statement.

A catalog appears in the result only after CREATE ICEBERG CATALOG registers it. LIKE and WHERE clauses can be parsed, but execution currently rejects them.

Syntax

SHOW ICEBERG CATALOGS

Arguments

SHOW ICEBERG CATALOGS takes no arguments. LIKE and WHERE clauses are parsed for compatibility but are not supported at execution time. The statement lists every Iceberg catalog registered for the current account.

Examples

SHOW ICEBERG CATALOGS;

See Also