Connect local H2 DB

[mlauber71]

@Nuke_Attokurov you can use the H2 Connector – KNIME Community Hub and just tell it where your H2 database file is.

Example how to use H2 database to create table with upload and from scratch –...

The drivers should be there. If you need a special version you can also add that:

SQLITE and Window Functions

@tobias.koetter thank you for this hint this opens up the whole world of window functions. I downloaded the latest JAR file from the Maven site and told KNIME where to find the driver. [image] [image] @khatuaani now you can benefit from the latest developments with H2 (and SQLite).