Icon

Prepare the Northwind Database

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

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

Nodes

Extensions

Links