DB Query Extractor (Labs)

Source

This node extracts the SQL query from a database data port and creates a flow variable and data table containing the query.

Input Ports

  1. Type: DB Data DB Data referencing the selected table

Output Ports

  1. Type: Flowvariable The SQL query as a flow variable
  2. Type: Data The SQL query as a string cell in a table with 1 row and 1 column.

Find here

KNIME Labs > DB (Labs) > Utility

Make sure to have this extension installed: