This workflow demonstrates the usage of the Python Script (DB) node that allows you to access data from a database directly within your Python script. Using this node you can alter the data within a database row by row without the need to load all the data at once. Notice, that the red connection ports of the database nodes only contain the SQL statement and connection information but not the data itself. The statement is processed within the database e.g. Oracle, MySQL, Postgres, DB2, SQL Server, Hive, Impala, etc. and the result is read into the KNIME Analytics Platform via the Database Connection Table Reader
Used extensions & nodes
Created with KNIME Analytics Platform version 4.1.0
Loading ad hoc executions
By using or downloading the workflow, you agree to our terms and conditions.
Discussions are currently not available, please try again later.