chris_stout
07/28/2022, 4:04 PMUpserting new rows into the table, using the primary key given by the tap connector (if it finds an old row with same key, updates it. Otherwise it inserts the new row)
We have set the:
table-key-properties:
- id
extended
- name: prod
config:
plugins:
extractors:
- name: tap-postgres--inventory
config:
default_replication_method: INCREMENTAL
metadata:
public-*:
replication-key: updated_date
table-key-properties:
- id
I thought this would solve the problem. Is there another field for the primary key I should be using instead of table-key-properties?