DB Table Selector

This node takes a DB Connection as input and allows to select a table or view from within the connected database. The node outputs a DB Data object which contains the database connection information as well as a database query that defines the data in the database.
In addition, this node allows to enter a customized SELECT statement which is then propagated to all connected nodes.

Options

Database name

The name of the database (or catalogue) to use.

Schema name

The database schema to read the table from. If not provided, the default schema of the database will be used.

Table name

Name of the database table to read data from. Must match the table name as it appears in the selected schema.

Custom query

An input field to enter the SELECT statement that should be propagated to all connected nodes. Optionally, the #table# placeholder can be used to refer to the table or view selected above.

Name

Columns that match the given name (or regular expression) and database type will be mapped to the specified KNIME type.

• Column selection type: The option allows you to select how the column is matched.
  • Manual: Use the exact name of the column
  • Regex: Allow regex expressions to select multiple columns
• Column name: The name or regex expression.
• Database type: SQL type to map from.
• Mapping to: Datatype to map to.

Type

Columns that match the given database type will be mapped to the specified KNIME type.

• From type: SQL type to map from.
• To type: Datatype to map to.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers