Cloud

ALTER ICEBERG CATALOG

The ALTER ICEBERG CATALOG statement modifies connection properties of an existing Iceberg catalog. You must repeat the STORAGE clause when altering, even if the storage connection is not changing.

Syntax

ALTER ICEBERG CATALOG [IF EXISTS] catalog_name STORAGE storage_name
WITH (option = 'value' [, ...]);

  • catalog_name: Name of the Iceberg catalog to modify.

  • IF EXISTS: Optional. Prevents an error if the Iceberg catalog does not exist.

  • storage_name: Name of the storage connection backing the catalog.

  • option = 'value': One or more connection options to update. See CREATE ICEBERG CATALOG for the full list of options.

Examples

Update the REST catalog URI for an existing Iceberg catalog:

ALTER ICEBERG CATALOG lakehouse_catalog STORAGE iceberg_storage
WITH (uri = 'https://new-catalog.example.com');

Rotate the basic-authentication credentials on an existing Iceberg catalog:

ALTER ICEBERG CATALOG lakehouse_catalog STORAGE iceberg_storage
WITH (
  auth_type = 'basic',
  username = '<new-username>',
  password = '<new-password>'
);