0 ×

Database Select Table (Interactive)

Vernalis custom KNIME database nodes package version 1.27.0.v202008190633 by Vernalis (R&D), UK

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

Best Friends (Incoming)

Best Friends (Outgoing)

Installation

To use this node in KNIME, install Vernalis KNIME Nodes from the following update site:

KNIME 4.2
Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.

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.