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.

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