Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • DB Table Selector
NodeNode / Source

DB Table Selector

DB Query
Drag & drop
Like
Copy short link

This node takes a DB Connection as input and allows to select a table or view from within the connected database. The node outputs a DB Data object which contains the database connection information as well as a database query that defines the data in the database.
In addition, this node allows to enter a customized SELECT statement which is then propagated to all connected nodes.

Node details

Input ports
  1. Type: DB Session
    DB Connection
    DB Connection to connecto to the database.
Output ports
  1. Type: DB Data
    DB Data
    DB Data referencing the data in the database.

Extension

The DB Table Selector node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    try to import netcdf into R and PostGIS
    R Netcdf Knime
    +3
    A collection of maybe useful links to websites concerning the import of netcdf data into …
    mlauber71 > Public > forum > kn_forum_import_netcdf > f_001_import_netcdf
  2. Go to item
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    deborah_santos > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 02 Accessing Databases
  3. 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 > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 02 Accessing Databases - Solution
  4. 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 > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 02 Accessing Databases - Solution
  5. Go to item
    01 Spark Connect Exercise Solution
    Big Data Education
    Big Data Course Spark Exercise #1 Solution Make sure you have executed the /2_Hadoop/2_Ex…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 3_Spark > 3_Solutions > 01_Spark_Connect
  6. Go to item
    02 DB InDB Processing Exercise
    Big Data Education
    Big Data Course DB Exercise #2
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 2_Exercises > 02_DB_InDB_Processing
  7. 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
  8. 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
  9. 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
  10. 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
  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