NodeDatabase Connection Table Writer (legacy)

Sink

This node is part of the legacy 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.

Input ports

  1. Database Connection Type: Database Query
    Database connection to a table

  1. Big Data Analytics - Model Selection to Predict Flight Departure Delays on Hive & Spark

    data blending data science machine learning Hadoop Spark model selection data preparation ETL airline data set flight delay
    This workflow trains a number of data analytics models on Hadoop and Spark and automatically selects the best model to p…
    knime > Examples > 50_Applications > 28_Predicting_Departure_Delays > 02_Scaling_Analytics_w_BigData

  2. In-Database Processing on SQL Server

    ETL KNIME Microsoft Azure In database Processing SQL Server
    This workflow shows how to perform in-database processing on Micrsoft SQL Server. It starts with a dedicated SQL Server …
    knime > Examples > 40_Partners > 01_Microsoft > 01_SQL_Server_InDB_Processing(Azure)

  3. Model Deployment SQL Recoding

    Deployment File Database SQL Recoding PMML Java Model Prediction Flight Delay
    This workflow demontstrates a mode of deploying a model with KNIME. The workflow reads new unseen data from a database, …
    knime > Examples > 50_Applications > 27_Deployment_Options > 02_Model_Deployment_SQL_Java_recoding