Parameterized Database Query

This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.

This node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.

This node runs SQL queries in the connected database restricted by the possible values given by the input table. It establishes and opens a database access connection from which to read data and restricts each SQL query so that only rows that match the possible values from the input table are retrieved.

Options

Database Column List: The list contains the columns that are available in the connected database table. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).
Column List: The list contains the columns that are available in the input table. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).
Flow Variable List: The list contains the flow variables that are currently available at the node input. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).
SQL Statement: Enter the SQL-like query here, for example SELECT * FROM table. If the table place holder isn't changed, then it will be replaced with the query from the database connection. Constant values and any identifier from the database column list, column list, flow variable list can be used in WHERE statement.
Fail on error: If checked, then the node will fail if there is any error. Otherwise, the node will continue executing and all errors will be collected in the second output table.
Append input columns: If checked, then the columns from the input table will be appended to the output table. Only columns that are used in the looping SQL statement will be appended.
Retain all columns: If checked, then all columns including columns that are not used in the looping SQL statement will be appended to the output table.
Include empty results: If checked, then all empty results will be appended to the output table and represented as Missing Cell. All input rows will be retained.

Input Ports

: Data column with possible values used to constrain the database SQL query
: A database query connection that will be used to connect to the database

Output Ports

: Table with data read from the database and optionally the data from the input table
: Table with error message if any, otherwise empty table

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

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 Base nodes from the below update site following our NodePit Product and Node Installation Guide:

v5.3

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

Plugin provider: KNIME AG, Zurich, Switzerland

Plugin version: 5.3.3.v202410291553

On NodePit since: 2024-07-09

Last update: 2024-11-15

Tags: Deprecated

KNIME versions: Since v3.6

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

Try NodePit Runner!