Skip to content
This repository has been archived by the owner on Sep 23, 2024. It is now read-only.

Use ORA_ROWSCN as replication-key #17

Open
LeqitSebi opened this issue Jun 21, 2023 · 0 comments
Open

Use ORA_ROWSCN as replication-key #17

LeqitSebi opened this issue Jun 21, 2023 · 0 comments
Labels
help wanted Extra attention is needed

Comments

@LeqitSebi
Copy link

In my meltano tap-oracle use case I do not have columns like "updated_at" for every table. It is also not possible to always add those. I've stumbled upon the pseudo_column ORA_ROWSCN which (as far as i understand) gets used by the extractor if a run is aborted. Would it be possible to also use the ORA_ROWSCN column as a replication_key to enable key-based incremental replication for tables without specific timestamp columns?

@LeqitSebi LeqitSebi added the help wanted Extra attention is needed label Jun 21, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

1 participant