This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementDB Connection Table WriterThis node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.
Writes the table from the input database connection into a new table inside the database. An already existing table will be dropped.
Options
Popular Predecessors
Database Sampling14 %Database Column Filter10 %Database Connection Table Writer9 %Database Table Connector3 %- Inject Variables (Database)3 %
Database Query3 %SQL Inject3 %Hive Loader (legacy)3 %Database Table Selector2 %Hive Connector2 %SQLite Connector2 %Database Numeric-Binner2 %- Wait...2 %
Database Row Filter2 %Database Connector2 %Extract Context Properties2 %H2 Connector2 %- String Input (legacy)2 %
Database Table Creator1 %Microsoft SQL Server Connector1 %Database Auto-Binner1 %Database Pivot1 %MySQL Connector1 %PostgreSQL Connector1 %CSV Writer< 1 %Database Joiner< 1 %Database SQL Executor< 1 %Database Column Rename< 1 %Database GroupBy< 1 %- String Manipulation (Variable)< 1 %
Run R Model in Microsoft SQL Server< 1 %- Database Select Table (Interactive) (Legacy)< 1 %
Database End CASE< 1 %- Extract Variables (Database)< 1 %
Database Sorter< 1 %Database Drop Table< 1 %- Decision Tree Predictor< 1 %
Python Script (DB)< 1 %Database IF Switch< 1 %- Create File Name (legacy)< 1 %
- Extract Variables (Data)< 1 %
Table Row to Variable< 1 %Table Row to Variable< 1 %Database Connection Table Reader< 1 %Database Writer< 1 %SQL Extract< 1 %- Java Edit Variable< 1 %
Loop End< 1 %- String Manipulation< 1 %
- Rule Engine Variable< 1 %
Impala Connector< 1 %Impala Loader (legacy)< 1 %Amazon Athena Connector< 1 %Amazon Redshift Connector< 1 %- Variable Expressions (legacy)< 1 %
Excel Reader (XLS)< 1 %- Java Edit Variable (simple)< 1 %
Views
- This node has no views
Workflows
01_SQL_Server_InDB_Processing(Azure)KNIME Hub- 02_Model_Deployment_SQL_Java_recodingKNIME Hub
- 02_Scaling_Analytics_w_BigDataKNIME Hub
- 02_Scaling_Analytics_w_BigDataKNIME Hub
- kn_example_bigdata_hive_add_columnKNIME Hub
- Show all 7 workflows
Links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.