This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementDB QueryThis node is part of the deprecated 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.
Options
Popular Successors
Database GroupBy11 %Database Query7 %Database Column Rename7 %Database Joiner4 %Database Pivot4 %Database Row Filter3 %Database Column Filter2 %Database Connection Table Writer2 %Database Reader2 %- Database To Variable (Legacy)2 %
Database Drop Table2 %Variable Loop End2 %Merge Variables2 %Create Date&Time Range2 %Database Writer2 %SQL Inject2 %Parameterized Database Query2 %- Text Output (legacy)2 %
Database Connection Table Reader1 %Database Sorter1 %Database Connector1 %- String Manipulation (Variable)1 %
Python Script (DB)1 %Database Update1 %- Table Creator1 %
Catch Errors (DB Ports)< 1 %Database Delete< 1 %Database Table Selector< 1 %Database IF Switch< 1 %Database Looping< 1 %Database Auto-Binner< 1 %CASE Switch Model (End)< 1 %- Send Email< 1 %
- Timer Info< 1 %
- Database List Tables (Legacy)< 1 %
Database End CASE< 1 %- DatabaseFilter< 1 %
- Catch Errors (Data Ports)< 1 %
- Extract Variables (Database)< 1 %
- Inject Variables (Database)< 1 %
CSV Reader< 1 %Database SQL Executor< 1 %SQL Extract< 1 %Database Numeric-Binner< 1 %Database Sampling< 1 %Database Table Creator< 1 %Model Writer< 1 %- Column Filter< 1 %
- End IF< 1 %
MySQL Connector< 1 %- DB Query Reader< 1 %
Excel Reader (XLS)< 1 %Excel Writer (XLS)< 1 %- Container Output (JSON)< 1 %
Views
- This node has no views
Workflows
01_Bioactivity_Prediction_Load_Pull_DataKNIME Hub- 01_SQL_Server_InDB_Processing(Azure)KNIME Hub
- 02_Model_Deployment_SQL_Java_recodingKNIME Hub
- 02_Scaling_Analytics_w_BigDataKNIME Hub
- 02_Scaling_Analytics_w_BigDataKNIME Hub
- Show all 6 workflows
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.