Cloud

SHOW CATALOGS

The SHOW CATALOGS statement lists catalogs in the cluster. Variants filter by catalog type: Redpanda catalogs or Iceberg catalogs.

SHOW CATALOGS and its variants only display catalogs in schemas where the user has the USAGE grant.

Syntax

SHOW CATALOGS;
SHOW REDPANDA CATALOGS;
SHOW KAFKA CATALOGS;
SHOW ICEBERG CATALOGS;

SHOW KAFKA CATALOGS is a synonym for SHOW REDPANDA CATALOGS.

Examples

List all catalogs

To list all catalogs (both Redpanda and Iceberg) visible to the caller:

SHOW CATALOGS;

For SQL-queryable access to the same information (with WHERE, ORDER BY, and LIMIT support), see system.catalogs.

List only Redpanda catalogs

SHOW REDPANDA CATALOGS;

List only Iceberg catalogs

SHOW ICEBERG CATALOGS;

For each Iceberg catalog’s REST endpoint, warehouse, and authentication type, see system.iceberg_catalogs or DESCRIBE ICEBERG CATALOG.