Duplicated owners with the same type

[DmytroYurchuk]

Describe the bug When assigning owners through ingestion using a transformer, duplicate owners appear for users who were previously assigned as owners via the UI with the same ownership role.

To Reproduce Steps to reproduce the behavior:

1. Assign an owner to a dataset via the UI. Example: assign user test1 as a Business Owner.
2. Configure simple_add_dataset_ownership transformer with config:

semantics: PATCH
replace_existing: False
owner_urns:
  - "urn:li:corpuser:[email protected]"
ownership_type: "BUSINESS_OWNER"

3. Run ingestion with the transformer.
4. Observe that the owner appears twice in the UI.

Expected behavior Only one owner should appear for the user, without duplicates.

Desktop (please complete the following information):

• DataHub version 1.3.0

[deepgarg760]

@DmytroYurchuk , can you share the result of the following queries after assigning the owner from both UI and transformer

select * from metadata_aspect_v2 mav where urn = ''

select * from metadata_aspect_v2 mav where urn = '' and mav.aspect = 'ownership' and mav.version = 0

[DmytroYurchuk]

Here are the results:

metadata_aspect_v2_202512011143.csv

metadata_aspect_v2_202512011143-1764582221885.csv