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 Predecessors
SQL Inject11 %Database Sorter7 %Database Connection Table Writer7 %Excel Writer (XLS)5 %Database Query4 %Table Row To Variable Loop Start4 %- Inject Variables (Database)3 %
Table Column to Variable3 %Amazon Athena Connector3 %Database Row Filter3 %Hive Loader (legacy)2 %Microsoft SQL Server Connector2 %- Extract Variables (Database)2 %
Database Connector2 %Database GroupBy2 %Table Row to Variable2 %Database Column Filter1 %Database Table Connector1 %Database Writer1 %- Group Loop Start1 %
SQL Extract1 %Database Numeric-Binner1 %- Database To Variable (Legacy)1 %
CSV Writer1 %Database Pivot1 %Database Table Creator1 %- Breakpoint< 1 %
Variable to Table Row< 1 %Database Joiner< 1 %Database Column Rename< 1 %Database Table Selector< 1 %- PMML to SQL< 1 %
Amazon Redshift Connector< 1 %H2 Connector< 1 %MySQL Connector< 1 %Date Input (legacy)< 1 %Python Script (DB)< 1 %Database IF Switch< 1 %Database Connection Table Reader< 1 %Hive Connector< 1 %- Integer Input (legacy)< 1 %
PostgreSQL Connector< 1 %SQLite Connector< 1 %Database End CASE< 1 %- Java Edit Variable< 1 %
- Rule Engine Variable< 1 %
Merge Variables< 1 %- String to Date&Time< 1 %
Database Auto-Binner< 1 %- Column Filter< 1 %
Impala Connector< 1 %- Double Input (legacy)< 1 %
Database CASE Switch< 1 %Database SQL Executor< 1 %Database Drop Table< 1 %Database Sampling< 1 %Extract Context Properties< 1 %Joiner< 1 %- String Manipulation (Variable)< 1 %
Vertica Connector< 1 %Excel Reader (XLS)< 1 %- String Input (legacy)< 1 %
Flow Variable IF Switch< 1 %- Wait...< 1 %
Catch Errors (DB Ports)< 1 %- Catch Errors (Var Ports)< 1 %
- Try (Variable Ports)< 1 %
- Active Branch Inverter< 1 %
Database Delete< 1 %Database Reader< 1 %Database Apply-Binner< 1 %- Column Resorter< 1 %
- String Manipulation< 1 %
CASE Switch Model (Start)< 1 %- DB GroupBy< 1 %
- Java Edit Variable (simple)< 1 %
- Date&Time Input (legacy)< 1 %
- Single Selection (legacy)< 1 %
- Container Output (JSON)< 1 %
- Database Connection Closer< 1 %
Table Row to Variable< 1 %- Table Row to Variable< 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.