Cloud

ALTER TABLE

The ALTER TABLE statement modifies the options of a catalog table mapped to a Redpanda topic.

Syntax

ALTER TABLE [IF EXISTS] catalog_name=>table_name
WITH (option = 'value' [, ...]);

  • catalog_name: Name of the Redpanda catalog containing the table.

  • table_name: Name of the table to modify.

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

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

Examples

Update the error handling policy for an existing catalog table:

ALTER TABLE default_redpanda_catalog=>sensor_readings
WITH (error_handling_policy = 'FILL_NULL');