Icon

kn_​forum_​python_​error_​sqlite_​41

using KNIME and SQLite to transfer data to Python and read it back

using KNIME and SQLite to transfer data to Python and read it back. An example from the forum but might be useful as an example how to combine SQLite and Python in KNIME

https://forum.knime.com/t/python-script-stopping-at-30/13602 db_sqlite_path_full=> determine full path of db.sqliteprev searches=> gives back the orginial filefor referencesample_data_python_error.tablesample_data_python_error.csvdummy_colresult.tabledb.sqlitedata1data2 Extract ContextProperties Java EditVariable (simple) Python Script (1⇒1) Table Writer File Reader Table Creator Table Writer SQLite Connector DB Writer DB Query Reader https://forum.knime.com/t/python-script-stopping-at-30/13602 db_sqlite_path_full=> determine full path of db.sqliteprev searches=> gives back the orginial filefor referencesample_data_python_error.tablesample_data_python_error.csvdummy_colresult.tabledb.sqlitedata1data2Extract ContextProperties Java EditVariable (simple) Python Script (1⇒1) Table Writer File Reader Table Creator Table Writer SQLite Connector DB Writer DB Query Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Mags Wildor
Created at: 2019-03-01
On NodePit since: 2020-07-29
Last update: 2024-04-27
Created with KNIME version: v4.1.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!