Icon

Update DB based on latest date

There has been no title set for this workflow's metadata.

This workflow demonstrates how to read and filter data on database level - this might be useful for people who want to load huge amounts of data incrementally and want to do the filtering already on the DB server instead of downloading it all to KNIME.

URL: The original post on the KNIME Forum https://forum.knime.com/t/row-filter-on-database-level-to-only-get-incremental-load-of-data/83720
URL: Link to Post in KNIME forum with explanation of Business Case https://forum.knime.com/t/row-filter-on-database-level-to-only-get-incremental-load-of-data/83720/12?u=kowisoft

WORKING SOLUTION this is only for documenting the thread,this solution didn't work - don't use it! importbase datawrite to DBconnect to in memory DBcreatevarMaxTime tbl varMaxTimeSQL to only read line items thatare newer thanvarMaxTimeCSV Reader DB Writer H2 Connector Table Creator Table Rowto Variable DB Query Reader _archive WORKING SOLUTION this is only for documenting the thread,this solution didn't work - don't use it! importbase datawrite to DBconnect to in memory DBcreatevarMaxTime tblvarMaxTimeSQL to only read line items thatare newer thanvarMaxTimeCSV Reader DB Writer H2 Connector Table Creator Table Rowto Variable DB Query Reader _archive

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m1pegv
Created at: 2024-10-11
On NodePit since: 2024-10-14
Last update: 2024-11-17
Created with KNIME version: v5.2.0
Tags: databasefilter

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!