Description

SHOW CATALOGS lists all accessible Catalogs in the current workspace, including locally managed Catalogs and External Catalogs.

Syntax

SHOW CATALOGS;

This command does not accept any parameters.

Return Fields

Examples

SHOW CATALOGS; +----------------------------+-------------------------+----------+ | workspace_name | created_time | category | +----------------------------+-------------------------+----------+ | clickzetta_sample_data | 2025-01-15 10:27:21.738 | SHARED | | databricks_main_catalog | 2025-11-20 12:00:49.498 | EXTERNAL | +----------------------------+-------------------------+----------+

View the list of Schemas in an external Catalog:

SHOW SCHEMAS IN clickzetta_sample_data;

Notes

• Only Catalogs that the current user has permission to access are displayed. Catalogs without permission will not appear in the results.
• External Catalogs (EXTERNAL type) must be registered in advance via CREATE EXTERNAL CATALOG, and the corresponding Catalog Connection must be in a connected state to be accessed normally.
• To view Schemas and tables within a Catalog, use SHOW SCHEMAS IN catalog_name and SHOW TABLES IN catalog_name.schema_name.