How to delete Duplicates (in DB)

Delete duplicates

1. Important: Do not change or delete directly in the database without a current backup!
2. Important: Only delete new added tuples (not changed once!)

Check for Duplicates

• Use BEXIS API DataQualityOut: GET /api/DataQuality/{id}
• Look for an identical variable combination

Table mvDATSETID

• Search for affected IDs based an identical variable combination
• collect always highest ID

Table datatuples

• Delete collected IDs

Update materialized view

• Click on "snyc" under Manage Datasets