Tanner Wilcox
09/04/2025, 6:50 PMTanner Wilcox
09/04/2025, 6:51 PMplugins:
extractors:
- name: sonar
inherit_from: tap-snowflake
variant: meltanolabs
config:
account: 1233
user: ext_3c255d90f6
password: ${SONAR_PASS}
warehouse: ETL_WAREHOUSE
database: TENANT_DATA_SNOWPIPE
schema: PUBLIC
metadata:
public-addresses_ext_3c255d82059647efba26c0996cec90f6:
replication-method: INCREMENTAL
replication-key: updated_at
updated_at:
is-replication-key: true
I want it to only pull a record from that address table if the updated_at is new but I want it to replace the previous record based on the IDTanner Wilcox
09/04/2025, 6:54 PMtable-key-properties: [id]
but that didn't seem to do anythingHolly Evans
09/04/2025, 7:51 PMmetadata:
public-addresses_ext_3c255d82059647efba26c0996cec90f6:
key_properties: ['id']
replication-key: updated_at
replication-method: INCREMENTAL
Holly Evans
09/04/2025, 7:51 PMtable-key-properties: [id]
, quotes needed?Tanner Wilcox
09/04/2025, 8:13 PM