0 ×

Parameterized Database Query

KNIME Base Nodes version 3.7.0.v201812031623 by KNIME AG, Zurich, Switzerland

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

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Update Site

To use this node in KNIME, install KNIME Base Nodes from the following update site:

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.