Node Connectivity

There are 72 nodes that can be used as successor for a node with an output port of type DB Data.

DB Query 

Modifies the SQL query that defines the incoming DB Data table.

DB Row Filter 

The DB Row Filter allows rows to be excluded from the input DB Data table.

DB Row Sampler StreamableModern UI

This node samples rows from a database table.

DB Sorter Modern UI

This node sorts the DB Data rows according to user-defined criteria.

DB Table Partitioner StreamableModern UI

The input table is split into two partitions (i.e. row-wise), e.g. train and test data.

DB Looping Streamable

This node runs SQL queries in the connected database restricted by the possible values given by the input table.

DB Reader Streamable

Executes the input query in the database and retrieves the result into a KNIME data table.

Parameterized DB Query Reader Streamable

This node runs SQL queries in the connected database restricted by the possible values given by the input KNIME data table.

DB Data Spec Extractor Modern UI

Extracts the column specification from a DB Data input port.

DB Query Extractor Modern UI

Extracts the SQL query from the input DB Data port.