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

DB Reader

DB Read/Write Streamable
Drag & drop
Like
Copy short link

Executes the input query in the database and retrieves the result into a KNIME data table.
If the node consumes a lot of memory you might want to decrease the "Fetch size" in the "Advanced" tab of the corresponding connector node. The fetch size specifies how many rows are fetched from the database server into KNIME per network round trip. The higher the number the more memory is consumed. However the smaller the number the more network round trips are necessary to fetch large results. Also not all JDBC driver support this option and thus might ignore it.

Node details

Input ports
  1. Type: DB Data
    DB Data
    DB Data connection with the query to execute.
Output ports
  1. Type: Table
    KNIME data table
    KNIME data table with the result form the database query.

Extension

The DB Reader node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    02 Accessing Databases - Solution
    Data access Sqlite
    Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The connect…
    knime > Education > Self-Paced Courses > Archive > L1-DS KNIME Analytics Platform for Data Scientists - Basics (deprecated) > Solutions > 02 Accessing Databases - Solution
    knime
  2. Go to item
    02 Accessing Databases - Solution
    Data access Sqlite Database
    Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The overall…
    knime > Education > Self-Paced Courses > Archive > L1-DW KNIME Analytics Platform for Data Wranglers - Basics (deprecated) > Solutions > 02 Accessing Databases - Solution
    knime
  3. Go to item
    05_Read_Data_from_Database - Solution
    E-learning Database Sqlite
    +1
    Solution to an e-learning course exercise. Access data on a SQLite database and read it i…
    stervis > Public > E-Learning > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 05_Read_Data_from_Database - Solution
    stervis
  4. Go to item
    05_Read_Data_from_Database - Solution
    E-learning Database Sqlite
    +1
    Solution to an e-learning course exercise. Access data on a SQLite database and read it i…
    stervis > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05_Read_Data_from_Database - Solution
    stervis
  5. Go to item
    02 Accessing Databases - Solution
    Data access Sqlite
    Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The connect…
    malgorzatagirda > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 02 Accessing Databases - Solution
    malgorzatagirda
  6. Go to item
    02 Accessing Databases - Solution
    Data access Sqlite Database
    Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The overall…
    kellytm2 > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 02 Accessing Databases - Solution
    kellytm2
  7. Go to item
    02 Accessing Databases - Solution
    Data access Sqlite
    Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The connect…
    deborah_santos > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 02 Accessing Databases - Solution
    deborah_santos
  8. Go to item
    02 Accessing Databases - Solution
    Data access Sqlite Database
    Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The overall…
    deborah_santos > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 02 Accessing Databases - Solution
    deborah_santos
  9. Go to item
    05_Read_Data_from_Database - Solution
    E-learning Database Sqlite
    +1
    Solution to an e-learning course exercise. Access data on a SQLite database and read it i…
    a2620 > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 05_Read_Data_from_Database - Solution
    a2620
  10. Go to item
    02 Accessing Databases - Solution
    Data access Sqlite
    Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The connect…
    sawskyowl > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 02 Accessing Databases - Solution
    sawskyowl
  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
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