DB Query Extractor (Labs)
This node extracts the SQL query from a database data port and creates a flow variable and data table containing the query.
- Type: DB Data DB Data referencing the selected table
- Type: Flowvariable The SQL query as a flow variable
- Type: Data The SQL query as a string cell in a table with 1 row and 1 column.
KNIME Labs > DB (Labs) > Utility
Make sure to have this extension installed: