Hub
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:

Related workflows & nodes

  1. 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. 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. 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
    rs1
  4. 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. 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. 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. 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
  8. 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
  9. 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
  10. SQL Set Operation (UNION) (migrated)
    iris > Public > SQL Set Operation (UNION) (migrated)
    iris