Hi, Laurent > Basically, I need to deduplicate, but only keeping in the deduplication state > the latest value of the changed column to compare with. While here it seems > to keep all previous values…
You can use ` ORDER BY proctime() DESC` in the deduplication query, it will keep last row, I think that’s what you want. BTW, the deduplication has supported event time in 1.12, this will be available soon. Best, Leonard