01_Using_Python_Script_in_Databases
Working with databases with the Python Script (DB) node
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
Nodes
- Python Script (DB)2 ×
- Create Temp Dir1 ×
- DB Reader (Labs)1 ×
- DB Table Selector (Labs)1 ×
- DB Writer1 ×
- Show all 7 nodes