DB Query (Labs)

Manipulator

Modifies the input SQL query from a incoming database connection. The SQL query is represented by the place holder #table# and will be replaced during execute. The new database connection is then available at the out-port. The database connection settings itself are not modified.

Input Ports

  1. Type: DB Data Database data connection

Output Ports

  1. Type: DB Data Database data connection with wrapped SQL query

Find here

KNIME Labs > DB (Labs) > Query

Make sure to have this extension installed: