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. 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
  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_rel372
  3. Prueba
    eduardomzci1 > Public > Prueba
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. Returning data for modified rows in PostgreSQL
    PostgreSQL Database Db
    This workflow demonstrates how the DB Query Reader node can be used to execute a DML stat…
    tobias.koetter > Public > DB > PostgreSQL > PostgresInsertWithReturn
  10. Create a SQLite table with R (and manipulate data)
    Sqlite R Database
    Create a SQLite table with R (and manipulate data) You can do all the stuff you want in R…
    mlauber71 > Public > kn_example_r_sqlite_multiple_tables_40