Home  /  Reference

ALTER TABLE

ALTER TABLE changes the parameters of a table.

Syntax

ALTER TABLE name SET ( RETAIN HISTORY = FOR retention_period )
ALTER TABLE name RESET ( RETAIN HISTORY )

Field Use
name The identifier of the table you want to alter.
retention_period Private preview. This option has known performance or stability issues and is under active development. Duration for which Materialize retains historical data, which is useful to implement durable subscriptions. Accepts positive interval values (e.g. '1hr'). Default: 1s.

Details

Back to top ↑