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.
Workflow
Fetch Data from SQLite Database
Used extensions & nodes
Created with KNIME Analytics Platform version 5.2.5
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.