NodeDatabase Query (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.

Modifies the input SQL query from a incoming database connection. The SQL query is represented by the place holder #table# and will be replaced during execute. The new database connection is then available at the out-port. The database connection settings itself are not modified.

Input Ports

  1. Port Type: Database Query
    Database connection

Output Ports

  1. Port Type: Database Query
    Database connection with wrapped SQL query

  1. 01_Bioactivity_Prediction_Load_Pull_Data

    This workflow is the first one executed by the model factory. It pulls the data from the ChEMBLdb (https://www.ebi.ac.uk…
    knime > Examples > 50_Applications > 37_Monster_Model_Factory > Process > _Process_Step_Templates > workflows > Templates > 01_Bioactivity_Prediction_Load_Pull_Data

  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. Databases - Advanced Usage

    Shows a KNIME workflow with a number of database nodes that directly work inside a database. Note, this flow uses the sq…
    knime > Examples > 01_Data_Access > 02_Databases > 02_Database_Advanced_Example

  4. 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

  5. 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