This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
This 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 Successors
- Molecule Type Cast7 %
- Reference Row Splitter5 %
Database Update5 %- Excel Writer5 %
Database Table Creator3 %- Legacy Date&Time to Date&Time3 %
- Binary Objects to Strings2 %
- Timer Info2 %
Database Writer2 %- String Manipulation2 %
- Joiner2 %
CSV Writer1 %Parameterized Database Query1 %- Group Loop Start1 %
- Constant Value Column1 %
- Double to Integer1 %
- Reference Row Filter1 %
Column Rename1 %- Scatter Plot (legacy)1 %
- Parallel Chunk End1 %
- Math Formula1 %
Number To String1 %- Duplicate Row Filter1 %
Recursive Loop End1 %Concatenate (Optional in)1 %- Row Filter1 %
- GroupBy1 %
Joiner1 %- Table to Image1 %
Excel Sheet Appender (XLS)1 %Database Delete< 1 %- Google Sheets Updater< 1 %
- Column Rename (Regex)< 1 %
- ARFF Writer< 1 %
Database Table Selector< 1 %Loop End< 1 %- Chunk Loop Start< 1 %
- Edit Numeric Domain< 1 %
- Column Filter< 1 %
- Row Splitter< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Sorter< 1 %
- Rule Engine< 1 %
- Cache< 1 %
- Parallel Chunk Start< 1 %
- Time to String (legacy)< 1 %
Cell Replacer< 1 %- Parameterized DB Query Reader< 1 %
- Date&Time to legacy Date&Time< 1 %
Variable Loop End< 1 %Cell Splitter< 1 %- Normalizer< 1 %
String Replace (Dictionary)< 1 %CASE Switch Data (End)< 1 %- Generic Web Service Client< 1 %
- Java Snippet (simple)< 1 %
- JSON Path< 1 %
- Date Field Extractor (legacy)< 1 %
- MarvinView< 1 %
- Inject Variables (Data)< 1 %
Database Column Filter< 1 %Database Connection Table Reader< 1 %- Column Aggregator< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Ungroup< 1 %
MySQL Connector< 1 %- String Input (legacy)< 1 %
- String to Date&Time< 1 %
Hive Loader (legacy)< 1 %Table Column to Variable< 1 %Database Looping< 1 %Table Writer< 1 %- Java Snippet< 1 %
- Loop End (Column Append)< 1 %
Naive Bayes Learner< 1 %- Simple Regression Tree Learner< 1 %
- Concatenate< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Column Resorter< 1 %
- Cross Joiner< 1 %
- HiLite Row Splitter< 1 %
- Rank< 1 %
- Regex Split< 1 %
- Unpivot< 1 %
- Value Counter< 1 %
- Rule-based Row Filter< 1 %
- Interactive Pie chart (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- OSM Map View< 1 %
Excel Writer (XLS)< 1 %- R View (Table)< 1 %
- Table Difference Checker< 1 %
- Date&Time-based Row Filter< 1 %
- RDKit Interactive Table< 1 %
- MolConverter< 1 %
- Wait...< 1 %
Variable to Table Column< 1 %List Files< 1 %Loop End (Column Append)< 1 %- Decision Tree to Image< 1 %
- Decision Tree Predictor< 1 %
- Cell Splitter< 1 %
- Column Combiner< 1 %
String To Number< 1 %Column Appender< 1 %- String Replacer< 1 %
- Rule-based Row Splitter< 1 %
- Rule Engine (Dictionary)< 1 %
- Empty Table Switch< 1 %
- Extract Table Dimension< 1 %
- HiLite Table (legacy)< 1 %
- Histogram (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- SDF Reader< 1 %
- Math Formula (Multi Column)< 1 %
- Bar Chart (JFreeChart)< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Table View (JavaScript)< 1 %
- JSON Row Combiner and Writer< 1 %
- Container Output (Table)< 1 %
- String to JSON< 1 %
- Object Inserter< 1 %
- XSLT< 1 %
- Text Classifier Learner< 1 %
Database Pivot< 1 %- DB GroupBy< 1 %
- External Tool< 1 %
- Google Sheets Writer< 1 %
- String to Date/Time (legacy)< 1 %
- CSV Writer< 1 %
- GET Request< 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.