Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • DB Query Reader
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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    query_peso_drg_custo_desfecho
    hiar_luis > Public > query_peso_drg_custo_desfecho
  2. Go to item
    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
  3. Go to item
    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
  4. Go to item
    Prueba
    eduardomzci1 > Public > Prueba
  5. Go to item
    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
  6. Go to item
    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
  7. Go to item
    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
  8. Go to item
    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
  9. Go to item
    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
  10. Go to item
    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
  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