Database Query

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: Database Query Database connection

Output Ports

  1. Type: Database Query Database connection with wrapped SQL query

Find here

Database > Manipulation

Make sure to have this extension installed:

KNIME Core

Update site for KNIME Analytics Platform 3.7:
KNIME Analytics Platform 3.7 Update Site

How to install extensions