Icon

Prepare the Northwind Database

Prepare the Northwind database into a consistant H2 db to provide a database environment to play with<br /><br />These tables are included in the local database<br />knime://knime.workflow/../data/Northwind_small.h2<br /><br />(they all have a unique ID "<tablename>id")<br /><br />shipper<br />product<br />customerdemographic<br />employee<br />customercustomerdemo<br />supplier<br />orders<br />category<br />region<br />employeeterritory<br />customer<br />orderdetail<br />territory<br /><br />one VIEW with a combination of informations<br />productdetails_v

URL: Northwind-SQLite3 https://github.com/jpwhite3/northwind-SQLite3
URL: SQL H2 - more examples https://hub.knime.com/search?tag=H2&type=Workflow

Prepare the Northwind database into a consistant H2 db to provide a database environment to play with
These tables are included in the local database
knime://knime.workflow/../data/Northwind_small.h2

(they all have a unique ID "id")

shipper
product
customerdemographic
employee
customercustomerdemo
supplier
orders
category
region
employeeterritory
customer
orderdetail
territory

one VIEW with a combination of informations
productdetails_v
Northwind_small.sqlite
SQLite Connector
$name_lower$ = "order" => "orders"TRUE => $name_lower$
Rule Engine
List allTables
DB Query Reader
name_lower
String Manipulation
get data fromproductdetails_vVIEW
DB Query Reader
loop databases
Table Row to Variable Loop Start
remove H2 VIEWproductdetails_v
DB SQL Executor
create tablenotes in long character
DB Table Structure Creator
lowercase column names
lowercase column names
List allViews
DB Query Reader
transfer to table
DB Writer
no lists
Column Filter
SHUTDOWN COMPACT;
DB SQL Executor
END
Variable Loop End
locate and create /data/ folder with absolute paths
Collect Local Metadata
set some PRIMARY KEYs
DB SQL Executor
List all Columnsof "PUBLIC"
DB Query Reader
DB Reader
v_big_data_schemaPUBLIC
String Input (legacy)
CREATE VIEWproductdetails_v
DB SQL Executor
DB Table Selector
remove H2 table
DB SQL Executor
Northwind_small.h2
H2 Connector
select all Tables
DB Query Reader

Nodes

Extensions

Links