Hub
NodeNode / Source

Database Table Selector (legacy)

DB Database (legacy) Read/Write (legacy)
Drag & drop
Like
Copy short link

This node is part of the legacy database framework and will be deprecated at the end of 2022. For more information on how to migrate to the new database framework see the migration section of the database documentation .

This node takes a database connection as input and allows selecting a table based on the incoming database JDBC connection. The node outputs the incoming connection together with the query which can later on be used in subsequent database manipulation nodes.

Node details

Input ports
  1. Type: Database Connection
    Database JDBC Connection
    A database connection to select a table from
Output ports
  1. Type: Database Query
    Database Connection
    A database connection with an initial table

Extension

The Database Table Selector (legacy) node is part of this extension:

Related workflows & nodes

  1. test 1
    liuzhang > Public > test 1
    liuzhang
  2. Basic RESTful Web Services Example 2
    Demonstrates how to create a REST-based web service that can be deployed via the KNIME Se…
    knime > Examples > 09_Enterprise > 01_Server > 01_RESTful_Services > 02_Create_basic_service2
    iris
  3. KNIME and SQLite - simple example (3.7 Legacy DB nodes)
    Sqlite Sql Db
    +2
    this demonstrates the use of a local SQLite database where you can store data and keep th…
    mlauber71 > Public > sqlite_knime_37 > t_001_sqlite_knime_37_db_legacy
    mlauber71
  4. Model Deployment SQL Recoding
    Deployment File Database
    +7
    This workflow demontstrates a mode of deploying a model with KNIME. The workflow reads ne…
    knime > Examples > 50_Applications > 27_Deployment_Options > 02_Model_Deployment_SQL_Java_recoding
    iris
  5. Mix and Match Predictive Approach. From Hive through In-Database Processing till KNIMEAnalytics Model Training.
    Hive ETL KNIME
    +4
    This workflow reads CENSUS data from a Hive database in HDInsight; it then performs some …
    knime > Examples > 40_Partners > 01_Microsoft > 03_HDI_Hive_KNIME
    tobias.koetter
  6. 01-FIRST_project
    danieltm1987 > Public > 01-FIRST_project
    danieltm1987
  7. add fields to Hive table
    Hive Sql Big data
    There has been no description set for this workflow's metadata.
    mlauber71 > Public > kn_example_bigdata_hive_add_column
    mlauber71
  8. Base General
    amatamorosa01 > Public > Base General
    amatamorosa01
  9. Mix and Match Predictive Approach. From BlobStorage and SQL Server through In-Database Processing till KNIMEAnalytics Model Training.
    BlobStorage ETL KNIME
    +4
    This workflow reads CENSUS data from a SQL Server database; it then performs some In-Data…
    knime > Examples > 40_Partners > 01_Microsoft > 02_SQLServer_BlobStorage_andKNIMEModels
    tobias.koetter
  10. In-Database Processing on SQL Server
    ETL KNIME Microsoft
    +3
    This workflow shows how to perform in-database processing on Micrsoft SQL Server. It star…
    knime > Examples > 40_Partners > 01_Microsoft > 01_SQL_Server_InDB_Processing(Azure)
    tobias.koetter