DB Select Table (Interactive)

The user can select the table type, schema name and table name. The dropdowns are re-populated dynamically on changing a selection in the table type or schema options

This node was developed by Vernalis Research . For feedback and more information, please contact knime@vernalis.com

Options

Table Type
The table type to use
Schema Name
The name of the schema
Table Name
The name of the table to use
Include Schema Name
Should the schema name be included in the SQL output? excluding the schema name results in more readable SQL at the risk of execution failure

Input Ports

Icon
Database connection

Output Ports

Icon
Database table connection with the table as selected in the node dialog

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, install the extension Vernalis KNIME Nodes from the below update site following our NodePit Product and Node Installation Guide:

v5.3

A zipped version of the software site can be downloaded here.

Plugin provider: Vernalis Research, UK
Plugin version: 1.36.7.v202405281205
On NodePit since: 2024-07-11
Last update: 2024-11-21
KNIME versions: v5.3, v5.2, v5.1, v4.7, v4.6, v4.5

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!