Procedure - address_fabric_1 - Latest

Identify all the records in the change file with change_type = 'D'. These represent records that should no longer exist in the dataset. Use the UUID to match and delete these from your master table.

DELETE FROM master_data
WHERE pbkey IN (
    SELECT pbkey FROM change_data WHERE change_type = 'D'
);

Fetch records from the change file where change_type is 'A'. These entries are new and should be added to your current dataset.

INSERT INTO master_data (pbkey, col1, col2, col3, ...)
SELECT pbkey, col1, col2, col3, ...
FROM change_data
WHERE change_type = 'A';

For records where change_type is 'U', update the corresponding attributes in the master dataset with values from the change file. Update should be done using the PBKEY as the matching key.

UPDATE master_data AS m
SET col1 = c.col1,
    col2 = c.col2,
    col3 = c.col3,
    ...
FROM change_data AS c
WHERE m.pbkey = c.pbkey
AND c.change_type = 'U';