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.

In Redpanda Cloud, the storage connection and Iceberg catalog used to query Iceberg-enabled topics are configured and managed automatically when you enable Redpanda SQL on a cluster that has an Iceberg REST catalog configured. You don’t run these statements yourself for that workflow. This page documents the statement’s syntax and options so you can understand what Redpanda Cloud configures. See Query Iceberg-enabled topics.

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>'
);