Hub
NodeNode / Source

DB Query Extractor

This node extracts the SQL query from the input DB Data port and creates a flow variable and a KNIME data table containing the query.

Node details

Input ports
  1. Type: DB Data
    DB Data
    DB Data with the database query to extract.
Output ports
  1. Type: Flow Variable
    SQL query flow variable
    The database query as a flow variable.
  2. Type: Table
    SQL query table
    The database query as a string cell in a table with 1 row and 1 column.

Extension

The DB Query Extractor node is part of this extension: