A watermark is the stored value, such as the last modification date processed, that marks how far the pipeline has read. On the next run, only the later rows are loaded: this is the principle of incremental loading. It must be updated only after a successful load.
Example
SELECT * FROM commandes WHERE modifie_le > :dernier_watermark