Node Connectivity

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

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 Looper Streamable

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

DB Parameterized 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 Reader Streamable

Executes the input query in the database and retrieves the result into a 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.

DB Type Mapper StreamableModern UI

Enables you to change the database to KNIME type mapping for subsequent nodes.