Icon

m_​000_​db_​prepare_​northwind_​db

Load tables from SQLite "Northwind" DB into H2 and make all columns lower case
Load tables from SQLite "Northwind" DB into H2 and make all columns lower case lowercase column namesNorthwind_small.sqliteSELECT * FROM "Customer"Northwind_small.h2tmp_OrderDetailv_big_data_schemaSELECT * FROM "OrderDetail" tmp_orderdetailtmp_customertmp_customertmp_producttmp_productSELECT * FROM "Product" SELECT * FROM "Order" tmp_ordertmp_orderlowercase column nameslowercase column nameslowercase column namestmp_producttmp_orderdetailtmp_customertmp_order lowercasecolumn names SQLite Connector DB Query Reader H2 Connector DB SQL Executor String Input DB Query Reader DB Writer DB SQL Executor DB Writer DB SQL Executor DB Writer DB Query Reader DB Query Reader DB SQL Executor DB Writer lowercasecolumn names lowercasecolumn names lowercasecolumn names DB Table Creator DB Table Creator DB Table Creator DB Table Creator Load tables from SQLite "Northwind" DB into H2 and make all columns lower case lowercase column namesNorthwind_small.sqliteSELECT * FROM "Customer"Northwind_small.h2tmp_OrderDetailv_big_data_schemaSELECT * FROM "OrderDetail" tmp_orderdetailtmp_customertmp_customertmp_producttmp_productSELECT * FROM "Product" SELECT * FROM "Order" tmp_ordertmp_orderlowercase column nameslowercase column nameslowercase column namestmp_producttmp_orderdetailtmp_customertmp_orderlowercasecolumn names SQLite Connector DB Query Reader H2 Connector DB SQL Executor String Input DB Query Reader DB Writer DB SQL Executor DB Writer DB SQL Executor DB Writer DB Query Reader DB Query Reader DB SQL Executor DB Writer lowercasecolumn names lowercasecolumn names lowercasecolumn names DB Table Creator DB Table Creator DB Table Creator DB Table Creator

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: A9699459
Created at: 2020-09-24
On NodePit since: 2020-09-25
Last update: 2024-04-27
Created with KNIME version: v4.4.1
Tags: sqlsqlitenorthwinddbdatabaseprepare

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

Try NodePit Runner!