DB_WHERE_IN
Fetch Data from Database
This example workflow shows how to retrieve data from SQLite database. Specifically, it shows how to select columns from a table and get records matching a specific condition.
Only the records satisfying the combined query conditions are retrieved from the database and they are retrieved only once by the DB Reader Node at the end of the workflow.
In this way, filtering prior to loading into KNIME can help save resources. The data can be handled similarly to KNIME’s native methods while utilizing the database's capabilities.
Nodes
- DB Reader (Labs)2 ×
- DB Column Filter (Labs)1 ×
- DB Query (Labs)1 ×
- DB Row Filter (Labs)1 ×
- DB Table Selector (Labs)1 ×
- Show all 10 nodes