Skip to content

ALTER SYSTEM

Synopsis

1
ALTER SYSTEM '<config-name>'='<value>';

Description

Sets and modifies the value of system-level configs. These are properties that are applied to all queries in the cluster. Using ALTER SYSTEM results in the new value being applied immediately across the cluster.

ALTER SYSTEM is only available from the ksql command line and only when connected to a ksqlDB cluster in Confluent Cloud.

Example

The following statement sets the streams property auto.offset.reset to begin at the earliest record in the input topics when no committed offsets are found.

1
ALTER SYSTEM 'auto.offset.reset'='earliest';

Last update: 2022-08-19