Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Query Extractor
NodeNode / Source

DB Query Extractor

DB Utility
Drag & drop
Like
Copy short link

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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    forum 44727 - 01 Practicing with Traditional Databases
    Big data Database H2
    +3
    forum 44727 - 01 Practicing with Traditional Databases
    mlauber71 > Forum > 2022 > kn_forum_44727_l4_bd_course_practice_db_tables
    mlauber71
  2. Go to item
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text …
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter2 > 1. Database_Operations
    jeany
  3. Go to item
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text …
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.3_20210222 > Chapter2 > 1. Database_Operations
    jeany
  4. Go to item
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text …
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.4_20210803 > AdvancedLuck > Chapter2 > 1. Database_Operations
    rs1
  5. Go to item
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text …
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.5_2022011 > AdvancedLuck > Chapter2 > 1. Database_Operations
    rs1
  6. Go to item
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text …
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.6_20220810 > AdvancedLuck > Chapter2 > 1. Database_Operations
    rs1
  7. Go to item
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text …
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.7_20230123 > AdvancedLuck > Chapter2 > 1. Database_Operations
    rs1
  8. Go to item
    School of duplicates - and how to deal with them - H2 version
    Sql Duplicates Remove
    +7
    Dealing with duplicates is a constant theme with data scientist. And a lot of things can …
    mlauber71 > Public > kn_example_duplicates_school_of_db_h2
    mlauber71
  9. Go to item
    example demonstrating how to manually enter a selected table and columns - or provide them via a configuation file
    H2 Select Component
    example demonstrating how to manually enter a selected table and columns - or provide the…
    mlauber71 > Forum > 2021 > kn_forum_36416_table_parameters
    mlauber71
  10. Go to item
    Hive/Big Data - a simple "self-healing" (automated) ETL or analytics system on a big data cluster
    Hive Big data Etl
    +2
    Hive/Big Data - a simple "self-healing" (automated) ETL or analytics system on a big data…
    mlauber71 > Public > kn_example_bigdata_hive_self_healing_jobs
    mlauber71

No known nodes available

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 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 Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits