Hub
NodeNode / Source

DB Query Reader

DB Read/Write
Drag & drop
Like
Copy short link

Executes an entered SQL query and returns the result as KNIME data table.

Node details

Input ports
  1. Type: DB Session
    DB Connection
    DB Connection to the database.
Output ports
  1. Type: Table
    KNIME data table
    KNIME data table with the result from the database query.

Extension

The DB Query Reader node is part of this extension:

Related workflows & nodes

  1. query_peso_drg_custo_desfecho
    hiar_luis > Public > query_peso_drg_custo_desfecho
    hiar_luis
  2. DB reading on a server from inside the workflow
    Beginner DB Database
    +1
    An example how to access an SQLite DB file inside workflow. Works both locally and on a K…
    lisovyi > Public > forum > 11962
    lisovyi
  3. DB reading on a server from inside the workflow
    Beginner DB Database
    +1
    An example how to access an SQLite DB file inside workflow. Works both locally and on a K…
    lisovyi > Public > forum > 11962_rel372
    lisovyi
  4. Prueba
    eduardomzci1 > Public > Prueba
    eduardomzci1
  5. Database - Simple IO
    Database Io Sqlite
    This workflow demonstrates using DB Query Reader and DB Writer nodes in a simple KNIME wo…
    knime > Examples > 01_Data_Access > 02_Databases > 01_Database_Simple_IO_Example
    tobias.koetter
  6. Database - Simple IO
    Database Io Sqlite
    This workflow demonstrates using DB Query Reader and DB Writer nodes in a simple KNIME wo…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 4_Examples > 01_Database_Simple_IO_Example
    knime
  7. Check Oracle Information (Version, Character Encoding, etc)
    Db Oracle Database
    This workflow executes the "SELECT * FROM v$version" query which returns the version of t…
    tobias.koetter > Public > DB > Oracle > OracleInformation
    tobias.koetter
  8. Database - Simple IO
    Database Io Sqlite
    This workflow demonstrates using DB Query Reader and DB Writer nodes in a simple KNIME wo…
    davin_sia > 01_Database_Simple_IO_Example > 01_Database_Simple_IO_Example
    davin_sia
  9. Database - Simple IO
    Database Io Sqlite
    This workflow demonstrates using DB Query Reader and DB Writer nodes in a simple KNIME wo…
    nicolassebey > Public > 01_Database_Simple_IO_Example
    nicolassebey
  10. Database - Simple IO
    Database Io Sqlite
    This workflow demonstrates using DB Query Reader and DB Writer nodes in a simple KNIME wo…
    emilio_s > Public Exercises > DL Italia > Lesson 1 > 5) 01_Database_Simple_IO_Example
    emilio_s