Deduplicate data in ClickHouse when a member of the sort key can change

I’m struggling a bit with deduplication and I was wondering if you had an idea on how we could solve this: