The sink is not deleting the previous key when receiving an update although I have those two options enabled:

    "iceberg.tables.cdc-field": "__op",
    "iceberg.tables.upsert-mode-enabled": "true",

I specified the key and partition like this:

...
    "iceberg.tables.default-id-columns": "id",
    "iceberg.tables.default-partition-by": "day(created_at)",

Looks like the sink connector won't delete records created by a debezium snapshot (__op = 'r').