KNIME Table SQL example

Example of using the KNIME Table Session Connector component to enable the execution of SQL directly against the data in the table.
The component uses the embedded H2 database to perform this, but this is effectively invisible to the user, who doesn't need to know about database creation, and inserting to the database tables.

The demo provides an alternative solution to the Query, in the form of KNIME nodes to emulate the various parts of the SQL select statement

@takbb Brian Bates 5 June 2024

External resources

• Forum post 80027 from which this demonstration originated