0 ×

Database Select Table (Interactive)

Vernalis custom KNIME database nodes package version 1.30.2.v202105111932 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


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

Best Friends (Incoming)

Best Friends (Outgoing)


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


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

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

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. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


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.