Hub
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:

Related workflows & nodes

  1. 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. 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. 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. 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
  5. 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
  6. 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
  7. 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…
    maarit > Public > E-Learning > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 05_Read_Data_from_Database - Solution
  8. 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…
    maarit > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05_Read_Data_from_Database - Solution
  9. 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
  10. 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