Page History

-- Explicit alteration of the definition query with reprocessing control
ALTER MATERIALIZED TABLE [catalog_name.][db_name.]table_name
[WITH (...)]
[SET START_MODE = FROM_BEGINNING 
             | FROM_NOW[(<interval_expression>)] 
             | FROM_TIMESTAMP(<timestamp_literal>)
             | RESUME_OR_FROM_BEGINNING 
             | RESUME_OR_FROM_NOW[(<interval_expression>)] 
             | RESUME_OR_FROM_TIMESTAMP(<timestamp_literal>)]
[SET STATE_RETENTION = ALL | NONE | PTF_ONLY]
AS <select_statement>