NodeDatabase SQL Executor (legacy)

Manipulator

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.

This node allows custom SQL Statements to be executed on the input database. The output port can be used for flow control, to prevent subsequent nodes from executing if the execution of this Statement fails.

Input ports
  1. Database Connection Type: Database Connection
    Connection to the database.
Output ports
  1. Database Connection Type: Database Connection
    Same as input.
  1. Snowflake meets Tableau
    snowflake data warehouse Hyper Tableau KNIME
    This workflow implements a DWH operation, configuring and launching a Snowflake in-cloud data warehouse instance. Sales …
    knime > Examples > 01_Data_Access > 02_Databases > 11_Snowflake_meets_Tableau
  2. 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
  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
  4. Big Data Preprocessing
    Hive Hadoop Big Data SQL in-database
    This workflow demonstrates the usage of the database nodes in conjunction with the Hive Connector node, which is part of…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 01_Big_Data_Preprocessing_Example