Icon

DB demo

Create a sample database table withsome demo data Local database(set to in memory, so lost each time this node is reset,but this makes it useful for demonstrations!create a db tableNode 3Node 4Select table, or custom queryFlow var connection ensuresthis can only run after table hasbeen createdused in conjunctionwith table selector to select the table tobe used as #table#free form queryreturn some datareturn the dataThis can perform "DDL" such as "Alter Table" statementsThis adds a new column called salaryThis can also perform "DML"such as free form update statementsfree form queryreturn some data H2 Connector DB Table Creator DB Insert Table Creator DB Table Selector DB Query DB Query Reader DB Reader DB SQL Executor DB SQL Executor DB Query Reader Create a sample database table withsome demo data Local database(set to in memory, so lost each time this node is reset,but this makes it useful for demonstrations!create a db tableNode 3Node 4Select table, or custom queryFlow var connection ensuresthis can only run after table hasbeen createdused in conjunctionwith table selector to select the table tobe used as #table#free form queryreturn some datareturn the dataThis can perform "DDL" such as "Alter Table" statementsThis adds a new column called salaryThis can also perform "DML"such as free form update statementsfree form queryreturn some dataH2 Connector DB Table Creator DB Insert Table Creator DB Table Selector DB Query DB Query Reader DB Reader DB SQL Executor DB SQL Executor 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: bbate
Created at: 2023-10-31
On NodePit since: 2023-10-31
Last update: 2024-05-02
Created with KNIME version: v4.7.7

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

Try NodePit Runner!