NodeNode / Sink

Database Connection Table Writer (legacy)

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 +7
    This workflow trains a number of data analytics models on Hadoop and Spark and automatically selects the best model to …
    knime > Examples > 50_Applications > 28_Predicting_Departure_Delays > 02_Scaling_Analytics_w_BigData
  2. Model Deployment SQL Recoding
    Deployment File Database +7
    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
  3. KNIME and SQLite - simple example (3.7 Legacy DB nodes)
    sqlite sql db +2
    this demonstrates the use of a local SQLite database where you can store data and keep the variable type and perform da…
    mlauber71 > Public > sqlite_knime_37 > t_001_sqlite_knime_37_db_legacy
  4. In-Database Processing on SQL Server
    ETL KNIME Microsoft +3
    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)
  5. Hive - how to get from DB-Connectors to Hive (or Impala) tables - Legacy nodes up to vers. 3.7.x
    big data hive impala +2
    Hive - how to get from DB-Connectors to Hive (or Impala) tables
    mlauber71 > Public > kn_example_hive_db_loader_37
  6. add fields to Hive table
    hive sql big data
    There has been no description set for this workflow's metadata.
    mlauber71 > Public > kn_example_bigdata_hive_add_column