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. Port Type: Database Connection
    Connection to the database.

Output Ports

  1. Port 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. 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

  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