DB Table Selector

This node takes a DB Connection as input and allows to select a table or view from within the connected database. The node outputs a DB Data object which contains the database connection information as well as a database query that defines the data in the database.
In addition, this node allows to enter a customized SELECT statement which is then propagated to all connected nodes.

Options

Database name
The name of the database (or catalogue) to use.
Schema name
The database schema to read the table from. If not provided, the default schema of the database will be used.
Table name
Name of the database table to read data from. Must match the table name as it appears in the selected schema.
Custom query
An input field to enter the SELECT statement that should be propagated to all connected nodes. Optionally, the #table# placeholder can be used to refer to the table or view selected above.
Name
Columns that match the given name (or regular expression) and database type will be mapped to the specified KNIME type.
  • Column selection type: The option allows you to select how the column is matched.
    • Manual: Use the exact name of the column
    • Regex: Allow regex expressions to select multiple columns
  • Column name: The name or regex expression.
  • Database type: SQL type to map from.
  • Mapping to: Datatype to map to.
Type
Columns that match the given database type will be mapped to the specified KNIME type.
  • From type: SQL type to map from.
  • To type: Datatype to map to.

Input Ports

Icon
DB connection to connect to the database.

Output Ports

Icon
DB Data referencing the data in the database.

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, install the extension KNIME Database from the below update site following our NodePit Product and Node Installation Guide:

v5.9

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland
Plugin version: 5.9.0.v202511130854
On NodePit since: 2025-12-11
Last update: 2026-01-12
Tags: StreamableModern UI
KNIME versions: Since v5.8

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!