Can I track updates to existing records in PostgreSQL?
Yes, you can track updates to existing records in your PostgreSQL table depending on the ingestion and query mode that you select while configuring it.
To do this:
-
Select Logical Replication as the ingestion mode in the Configure your PostgreSQL Source page.
-
Use the Delta-Timestamp or Change Data Capture query modes for your objects if you are using Table ingestion mode in the Configure Objects page.
Last updated on May 30, 2023