Icon

DB SQL - H2 Database, create database and additional tables

URL: KNIME, Databases and SQL https://medium.com/p/273e27c9702a
URL: Practicing with Traditional Databases https://hub.knime.com/-/spaces/-/~DgfgZ8jjSOK6s1bF/current-state/
URL: DB SQL - H2 Database, create database and additional tables - KNIME Forum (77916) https://forum.knime.com/t/table-transfer/77916/9?u=mlauber71
URL: KNIME Database Extension Guide https://docs.knime.com/latest/db_extension_guide/index.html#intro

DB SQL - H2 Database, create database and additional tables

https://forum.knime.com/t/table-transfer/77916/9?u=mlauber71

KNIME, Databases and SQL

https://medium.com/p/273e27c9702a

Create the structure of the database (empty)

Insert the data into the database

Practicing with Traditional Databases

https://hub.knime.com/s/DgfgZ8jjSOK6s1bF

DB Table Selector
my_table_205CREATE
DB Writer (DB Data)
my_table_205APPEND
DB Writer (DB Data)
DB Query Reader
SELECT * FROM #table# AS "t1"WHERE "Counter" <= 25
DB Query
SELECT * FROM #table# AS "t2"WHERE "Counter" > 25
DB Query
my_table_001string as longvarchar
DB Table Creator (deprecated)
bulk insert the data
DB Writer
Table Partitioner
resetthis is a databasein memory just to show how this could work
H2 Connector
SELECT * FROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME = 'my_table_201'
DB Query Reader
SELECT * FROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME = 'my_table_001'
DB Query Reader
just get a DBconnection here
DB Connection Extractor
insert therest of the dataset
DB Insert (deprecated)
my_table_005CREATE
DB Writer (DB Data)
my_table_001select the table you want.Will appear as #table# in the'brown' database nodes
DB Table Selector (deprecated)
SELECT * FROM #table# AS "t2"WHERE "Counter" > 25
DB Query
my_table_005APPEND
DB Writer (DB Data)
SELECT * FROM #table# AS "t1"WHERE "Counter" <= 25
DB Query
my_table_201
DB Table Deleter
insert therest of the dataset
DB Row Inserter
https://hub.knime.com/-/spaces/-/~4-Nz2crmY1OvrH_M/current-state/
Create Dummy Data
my_table_001
DB Table Deleter
my_table_201string as longvarcharunder Columns (dynamic) -> Set Types
DB Table Structure Creator
just get a DBconnection here
DB Connection Extractor

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: m_lauber
Created at: 2024-03-18
On NodePit since: 2024-03-19
Last update: 2026-03-17
Created with KNIME version: v5.10.0
Tags: DBSQLdatabaseH2

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

Try NodePit Runner!