Hi! i have used the QueryDatabaseTable processor to query rows incrementally, that is only the new rows added at the source after the last sync, but somehow i haven't been able to also get the rows that have been modified, is there an easy way to do this in nifi?
Hi Shu! Thanks for the reply. I can already do an incremental fetch, what i'm asking for is a way to also get the rows that have been already synced, but that have been modified since last fetch. For this i would have a column with a last_modified date.
I am also looing for same.I am able to get incremental data but what if rows is modified ,querydatabasetable processor is unable to fetch those modified records.Please let me know if u get this solution.