Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
Sign in
  • KNIME Hub
  • Nodes
  • DB Query Extractor
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:

Related workflows & nodes

  1. Database Operations
    KNIME Advanced Luck Books Database +2
    This workflow shows how to connect to a database and implement SQL queries, as free text or using the database nodes.
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter2 > 1. Database_Operations
  2. Database Operations
    KNIME Advanced Luck Books Database +2
    This workflow shows how to connect to a database and implement SQL queries, as free text or using the database nodes.
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.3_20210222 > Chapter2 > 1. Database_Operations
  3. SQL Set Operation (UNION) (migrated)
    iris > Public > SQL Set Operation (UNION) (migrated)
  4. Rossmann - DB - Time Series
    mwysocki > Public > Rossmann - DB - Time Series
  5. Rossmann - DB - Time Series(2)
    mwysocki > Public > Rossmann - DB - Time Series(2)

No known nodes available

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2021 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits