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 ReplacementParameterized DB Query ReaderThis 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.
This node runs SQL queries in the connected database restricted by the possible values given by the input table. It establishes and opens a database access connection from which to read data and restricts each SQL query so that only rows that match the possible values from the input table are retrieved.
Options
Popular Predecessors
- Java Snippet5 %
- GroupBy4 %
File Reader3 %CSV Reader3 %- Table Creator3 %
- Excel Reader2 %
Database Column Filter2 %- SDF Reader2 %
- String to Date&Time2 %
SQL Extract2 %Excel Writer (XLS)2 %- Parameterized DB Query Reader1 %
- CSV Reader1 %
Table Row To Variable Loop Start1 %Variable to Table Row1 %Database Connector1 %- MolConverter1 %
- Linear Regression Learner1 %
- Column Resorter1 %
Joiner1 %- String Manipulation1 %
- Math Formula1 %
Generic Loop Start< 1 %Database Writer< 1 %- Joiner< 1 %
Column Appender< 1 %- Column Filter< 1 %
- Reference Row Splitter< 1 %
- Number Rounder< 1 %
- Java Snippet Row Filter< 1 %
- Date&Time Shift< 1 %
Database Query< 1 %Parameterized Database Query< 1 %Database Pivot< 1 %Database Table Creator< 1 %Row Filter (deprecated)< 1 %Column Rename< 1 %- Cache< 1 %
Excel Reader (XLS)< 1 %- String to Date/Time (legacy)< 1 %
Database Table Connector< 1 %Database Reader< 1 %Database Table Selector< 1 %Database Drop Table< 1 %Table Reader< 1 %Interval Loop Start< 1 %- Decision Tree Predictor< 1 %
- Concatenate< 1 %
String To Number< 1 %- Partitioning< 1 %
- RowID< 1 %
- Row Sampling< 1 %
- Ungroup< 1 %
- Rule-based Row Filter< 1 %
Amazon Redshift Connector< 1 %- Parallel Chunk Start< 1 %
SQLite Connector< 1 %- R Source (Table)< 1 %
- Column Auto Type Cast< 1 %
- String to Number< 1 %
- Duplicate Row Filter< 1 %
- Python Source (legacy)< 1 %
- DB Query Reader< 1 %
- Table View (JavaScript)< 1 %
Database Column Rename< 1 %- Chunk Loop Start< 1 %
Cell Replacer< 1 %Row Splitter (deprecated)< 1 %- String Replacer< 1 %
- Lift Chart (legacy)< 1 %
Variable to Table Column< 1 %- Add Empty Rows< 1 %
- Date&Time Input (legacy)< 1 %
- Variable to Table Row< 1 %
Table Row to Variable< 1 %Database Joiner< 1 %Database Row Filter< 1 %Database GroupBy< 1 %Number To String< 1 %- Domain Calculator< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Filter< 1 %
- Missing Value< 1 %
- Parallel Chunk End< 1 %
- Java Snippet (simple)< 1 %
- Value Filter (legacy)< 1 %
- XPath< 1 %
- Cell Splitter< 1 %
Excel Reader (XLS)< 1 %- Wait...< 1 %
Table Column to Variable< 1 %Database SQL Executor< 1 %- Column List Loop Start< 1 %
Cell Splitter< 1 %- Nominal Value Row Filter< 1 %
- Empty Table Switch< 1 %
PostgreSQL Connector< 1 %- Date/Time Shift (legacy)< 1 %
Line Reader< 1 %Vertica Connector< 1 %- Column Filter (legacy)< 1 %
- JSON to Table< 1 %
- Create Date&Time Range< 1 %
- Table Row to Variable Loop Start< 1 %
- Create Collection Column< 1 %
- Inject Variables (Database)< 1 %
Database Connection Table Reader< 1 %Database Update< 1 %Database Looping< 1 %SQL Inject< 1 %- Java Edit Variable< 1 %
Loop End< 1 %- Group Loop Start< 1 %
- Case Converter< 1 %
- Constant Value Column< 1 %
- Cross Joiner< 1 %
- Double to Integer< 1 %
- HiLite Row Splitter< 1 %
- Pivot< 1 %
- Sorter< 1 %
- Table Transposer< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
MySQL Connector< 1 %Microsoft SQL Server Connector< 1 %- Empty Table Creator< 1 %
XLS Reader< 1 %Excel Reader (XLS)< 1 %Date Input (legacy)< 1 %- List Box Input (legacy)< 1 %
- Table to JSON< 1 %
- R Snippet< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Date Field Extractor (legacy)< 1 %
- Database List Tables (Legacy)< 1 %
- Database Select Table (Interactive) (Legacy)< 1 %
- Load Text Files< 1 %
- Database Connector< 1 %
- File Meta Info (legacy)< 1 %
- Files to Binary Objects< 1 %
- List Remote Files (legacy)< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
Database Delete< 1 %Database Sampling< 1 %Extract Context Properties< 1 %List Files< 1 %Recursive Loop Start< 1 %Variable Loop End< 1 %K Nearest Neighbor< 1 %Concatenate (Optional in)< 1 %- Number to String< 1 %
- Column Aggregator< 1 %
- Column Renamer (Dictionary)< 1 %
Linear Correlation< 1 %- Reference Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Decision Tree to Ruleset< 1 %
- Statistics< 1 %
- IF Switch< 1 %
CASE Switch Data (Start)< 1 %- Extract Table Spec< 1 %
Merge Variables< 1 %- Crosstab< 1 %
Hive Connector< 1 %Impala Connector< 1 %Impala Loader (legacy)< 1 %- Molecule Type Cast< 1 %
H2 Connector< 1 %- Oracle Connector< 1 %
- Model Loop Start< 1 %
- OpenBabel< 1 %
- NGram Creator< 1 %
- Double Input (legacy)< 1 %
- String Input (legacy)< 1 %
- List Box Widget< 1 %
- JSON Row Combiner< 1 %
- Container Input (Table)< 1 %
- Container Input (JSON)< 1 %
- JSON Path< 1 %
MongoDB Reader< 1 %- Parameter Optimization Loop End< 1 %
- Modify Time< 1 %
- Window Loop Start< 1 %
- Table Column to Variable< 1 %
- Scorer< 1 %
- Constant Value Column Filter< 1 %
- Read Excel Sheet Names< 1 %
- Date&Time Difference< 1 %
- Date&Time-based Row Filter< 1 %
- Modify Date< 1 %
Views
- This node has no views
Workflows
01-FIRST_projectKNIME Hub- 02_Create_basic_service2KNIME Hub
- Data by Date inputdateKNIME Hub
- dbLooping_parameterizedKNIME Hub
- dbLooping_parameterized_flowvar_SQLKNIME Forum
Links
- How to send parameter to SQL in syntax where parameter in()by ipazin on 2019-03-01forum.knime.com/p/55452
- Entering values into a DB Queryby izaychik63 on 2019-02-21forum.knime.com/p/54962
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.