Why does my Destination have records that are deleted in the Source?

When a record is deleted in the Source, Hevo updates the metadata column, hevo_marked_deleted, for it to True in the Destination. This means that Hevo does not permanently delete the record in the Destination. Instead, it performs a soft delete. You can identify the records deleted in the Source using the hevo_marked_deleted field.