SHOW ICEBERG TABLES¶

SHOW ICEBERG TABLES lists Iceberg table mappings visible to the current account.

Description¶

The result contains catalog, namespace, table, ref, read_mode, and write_mode columns. Use one of the catalog and namespace forms below to narrow the listing. LIKE and WHERE clauses are parsed for compatibility but are not supported at execution time.

Syntax¶

SHOW ICEBERG TABLES
SHOW ICEBERG TABLES FROM catalog_name
SHOW ICEBERG TABLES FROM catalog_name.namespace
SHOW ICEBERG TABLES IN CATALOG catalog_name
SHOW ICEBERG TABLES IN NAMESPACE namespace
SHOW ICEBERG TABLES IN NAMESPACE namespace IN CATALOG catalog_name

Examples¶

SHOW ICEBERG TABLES;
SHOW ICEBERG TABLES FROM prod_catalog;
SHOW ICEBERG TABLES FROM prod_catalog.sales;
SHOW ICEBERG TABLES IN CATALOG prod_catalog;
SHOW ICEBERG TABLES IN NAMESPACE sales;
SHOW ICEBERG TABLES IN NAMESPACE sales IN CATALOG prod_catalog;

See Also¶