Database Select Table (Interactive) (Legacy)

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

: Database connection

Output Ports

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

Views

This node has no views

Workflows

No workflows found

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.2

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

Plugin provider: Vernalis Research, UK

Plugin version: 1.36.5.v202312051850

On NodePit since: 2023-12-06

Last update: 2024-04-23

KNIME versions: v5.2, v5.1, v4.7, v4.6, v4.5, v4.4, v4.3, v4.2, v4.1, v4.0, v3.7, v3.6

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

Try NodePit Runner!