Data Cleaning Exercises

Pro exercise

Load only rows after the high-water mark

An incremental load picks up rows changed since the last run. The previous run's high-water mark is 2026-03-01 12:00 UTC: load rows updated strictly after that instant, compared as instants, so a row stamped 13:00+01:00 (the mark itself) isn't loaded twice.

  • incremental loads
  • timestamps
  • boundaries

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.