Fetch Data from SQLite Database

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.