DB Table Selector

Source

This node takes a database connection as input and allows selecting a table or view based on the incoming database connection. The node outputs the incoming connection together with the query referencing the selected table or view which can be used in subsequent database nodes. In addition, this node allows a customized SELECT statement to narrow the results window for the next node(s).

Input Ports

  1. Type: DB Session
    DB Connection

Output Ports

  1. Type: DB Data
    DB Data referencing the selected table

  1. DB Looping and Parameterized Reader Nodes

    This workflow demonstrates the legacy Database Looping and Parameterized Database Query node as well as the new Paramete…
    Users > tobias.koetter > DB

  2. Send data to tableau server example

    Tableau
    This workflow reads the data of the last 24 hours from a database and sends it to a tableau server. If the workflow is u…
    Users > kathrin > Forum_Question_Tableau_Example

  3. Fetch ChEMBL Target Data Meta Information

    Jupyter Python topic modeling database text mining ChEMBL
    This workflow uses a query against a SQL version of the ChEMBL database to retrieve a bunch of information about user-pr…
    Users > knime > Examples > 07_Scripting > 03_Python

Extension

This node is part of the extension

KNIME Database

 v4.0.0

Short Link

Drag node into KNIME Analytics Platform