I am new to Knime and to databases. I have been able to conect to my DB with the DB Reader node and I want to be able to update the output table every week. However, the amount of rows are aprox 28 million rows and I want to be able to update the output table without having to do the request of ALL rows each time I run the DB reader. In other words: Is there a way to update the request for the rows that are not on the current output table and include the new rows in the database?
I hope this makes sence, sorry if I confused, english is not my first lenguage.
Thank you in advance!