Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • SQL Extract (legacy)
NodeNode / Other

SQL Extract (legacy)

DB Database (legacy) Utility (legacy)
Drag & drop
Like
Copy short link

This node is part of the legacy database framework and will be deprecated at the end of 2022. For more information on how to migrate to the new database framework see the migration section of the database documentation .

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

Node details

Input ports
  1. Type: Database Query
    Database Port
    A database port with a connection and a query
Output ports
  1. Type: Flow Variable
    SQL query flow variable
    The SQL query as a flow variable
  2. Type: Table
    SQL query table
    The SQL query as a string cell in a table with 1 row and 1 column.

Extension

The SQL Extract (legacy) node is part of this extension:

  1. Go to item

Related workflows & nodes

    1. Go to item
    2. Go to item
    3. Go to item
    4. Go to item
    5. Go to item
    6. Go to item

    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
    © 2022 KNIME AG. All rights reserved.
    • Trademarks
    • Imprint
    • Privacy
    • Terms & Conditions
    • Credits