Cloud

ALTER REDPANDA CATALOG

The ALTER REDPANDA CATALOG statement modifies connection properties of an existing Redpanda catalog. You can also use it to link the Redpanda catalog to an Iceberg catalog (or detach an existing link) so that queries against the Redpanda catalog return both live records and Iceberg-translated history (records previously written from the topic into the linked Iceberg catalog). See Query Iceberg-enabled Topics for details.

Syntax

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

ALTER REDPANDA CATALOG [IF EXISTS] catalog_name
USING CATALOG [schema.]iceberg_catalog_name
[WITH (option = 'value' [, ...])];

ALTER REDPANDA CATALOG [IF EXISTS] catalog_name
USING CATALOG NULL
[WITH (option = 'value' [, ...])];

  • catalog_name: Name of the Redpanda catalog to modify.

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

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

  • USING CATALOG iceberg_catalog_name: Links the Redpanda catalog to an existing Iceberg catalog. The Iceberg catalog must already exist. You can qualify the Iceberg catalog name with a schema prefix.

  • USING CATALOG NULL: Detaches the Redpanda catalog from any linked Iceberg catalog.

Examples

Update broker address

ALTER REDPANDA CATALOG production_redpanda
WITH (initial_brokers = 'new-broker:9092');

To link a Redpanda catalog to an existing Iceberg catalog so that queries against the Redpanda catalog return both live records and Iceberg-translated history:

ALTER REDPANDA CATALOG production_redpanda
USING CATALOG lakehouse_catalog;

To change which Iceberg catalog a Redpanda catalog is linked to, run ALTER REDPANDA CATALOG …​ USING CATALOG <new-iceberg-cat>:

ALTER REDPANDA CATALOG production_redpanda
USING CATALOG new_lakehouse_catalog;

Detach from an Iceberg catalog

To remove an existing link to an Iceberg catalog so that queries against the Redpanda catalog return only live records:

ALTER REDPANDA CATALOG production_redpanda
USING CATALOG NULL;