Icon

How to Modify Database Tables

<p><strong>How to Modify Database Tables</strong></p><p>This workflow demonstrates how to create a new database table, write data from KNIME into a database, write in-database processed data into a new database table, and read data from database into KNIME. Lastly, it also shows how to remove an existing table from the database.</p>

URL: KNIME Database Extension Guide https://docs.knime.com/latest/db_extension_guide/index.html

Write data from KNIME to a database

Read data from database into KNIME

Write data processed on a database to a database

How to Modify Database Tables


This workflow demonstrates how to create a new database table, write data from KNIME into a database, write in-database processed data into a new database table, and read data from database into KNIME. Lastly, it also shows hot to remove an existing table from the database.

Remove a database table

In-database data processing

Alternative

Import backto KNIME
DB Reader
Change typeString to Local Date Time
DB Type Mapper
Remove existingtable
DB Table Deleter
Create a newtable
DB Table Structure Creator
Write todatabasedirectly
DB Writer (DB Data)
Descendsort
DB Sorter
DB Column Renamer
Insert the data
DB Row Inserter
Connect todatabase
H2 Connector
Global newson Tourism
GDELT Global Knowledge Graph
Filter outgeometry column
DB Column Filter
Create a new table and directly insert the data
DB Writer

Nodes

Extensions

Links