This node runs SQL queries in the connected database restricted by the possible values given by the KNIME input table. It restricts each SQL query so that only rows that match the possible values from the input table are retrieved.
Options
Settings
Input Type Mapping
This tab allows you to define rules to map from database types to KNIME types.
Output Type Mapping
This tab allows you to define rules to map from KNIME types to database types.
Popular Predecessors
- DB Table Selector15 %
- Duplicate Row Filter15 %
- Table Creator4 %
- DB Query3 %
Row Filter (deprecated)3 %- GroupBy2 %
- Excel Reader2 %
- Joiner2 %
- DB Row Filter2 %
- DB Reader1 %
Column Rename1 %- Parameterized DB Query Reader1 %
- DB Query Reader1 %
- Column Filter1 %
- String Manipulation1 %
- DB Column Filter1 %
- DB Writer< 1 %
- DB Query Injector< 1 %
- Parallel Chunk Start< 1 %
- DB Joiner< 1 %
- Cross Joiner< 1 %
- Rule-based Row Filter< 1 %
- Number to String< 1 %
- Empty Table Creator< 1 %
- CSV Reader< 1 %
- Top k Row Filter< 1 %
Joiner< 1 %- Reference Row Splitter< 1 %
- Sorter< 1 %
- End IF< 1 %
- String Input (legacy)< 1 %
- Date&Time-based Row Filter< 1 %
- Data Generator< 1 %
- Breakpoint< 1 %
CSV Reader< 1 %- Concatenate< 1 %
- Nominal Value Row Filter< 1 %
- Rule Engine< 1 %
- SDF Reader< 1 %
- DB GroupBy< 1 %
- DB Query Extractor< 1 %
- Table View (JavaScript)< 1 %
- Extract Missing Value Cause< 1 %
Table Row to Variable< 1 %- Java Snippet< 1 %
- Chunk Loop Start< 1 %
- Column Resorter< 1 %
Row Splitter (deprecated)< 1 %- Ungroup< 1 %
- DB Type Mapper< 1 %
- Container Input (Row)< 1 %
- Table Column to Variable< 1 %
- Variable to Table Row< 1 %
- Case Converter< 1 %
- Column Appender< 1 %
- Try (Data Ports)< 1 %
CSV Writer< 1 %Database Reader< 1 %- Column List Loop Start< 1 %
- String to Number< 1 %
- Reference Row Filter< 1 %
- Missing Value< 1 %
- DB Delete (Table)< 1 %
- Math Formula< 1 %
- Container Input (Table)< 1 %
- Benchmark Start< 1 %
- Table Row to Variable< 1 %
- Table Row to Variable Loop Start< 1 %
- Table Manipulator< 1 %
- Partitioning< 1 %
- Counter Generation< 1 %
- Nominal Row Filter Configuration< 1 %
- CASE Switch Start< 1 %
- Column Aggregator< 1 %
- Google Sheets Reader< 1 %
- Inject Variables (Data)< 1 %
Table Reader< 1 %- Group Loop Start< 1 %
- Constant Value Column< 1 %
- Double to Integer< 1 %
- String Manipulation (Variable)< 1 %
- Rule-based Row Splitter< 1 %
- Empty Table Switch< 1 %
CASE Switch Data (Start)< 1 %- DB Insert< 1 %
- DB Merge< 1 %
- DB Update< 1 %
- DB Pivot< 1 %
- DB Sorter< 1 %
- Column Expressions (legacy)< 1 %
- Date&Time to String< 1 %
- String to Date&Time< 1 %
- Create Date&Time Range< 1 %
- Date&Time Shift< 1 %
- File Reader< 1 %
- Table Reader< 1 %
- Cell Splitter By Position< 1 %
- Column Combiner< 1 %
- Row Sampling< 1 %
- Table Transposer< 1 %
- DB Row Sampling< 1 %
- Variable Expressions (legacy)< 1 %
- Java Snippet (simple)< 1 %
- Date&Time Configuration< 1 %
- String Configuration< 1 %
- Nominal Row Filter Widget< 1 %
- List Box Widget< 1 %
- Python Script (legacy)< 1 %
- String Widget< 1 %
- MarvinSketch< 1 %
Loop End< 1 %- DB Connection Table Writer< 1 %
Excel Reader (XLS)< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Column Auto Type Cast< 1 %
- Math Formula (Multi Column)< 1 %
- Value Filter (legacy)< 1 %
Table Column to Variable< 1 %Parameterized Database Query< 1 %File Reader< 1 %Interval Loop Start< 1 %Number To String< 1 %- Column Splitter< 1 %
- DB Partitioning< 1 %
- Variable to Table Column< 1 %
- Create Table Structure< 1 %
- XLS Control Table Generator< 1 %
- Missing Value Column Filter< 1 %
- Number to String (PMML)< 1 %
- IF Switch< 1 %
DB Loader< 1 %- Multiple Selection Configuration< 1 %
- Date&Time to legacy Date&Time< 1 %
- Binary Objects to PNGs< 1 %
CASE Switch Data (End)< 1 %- Merge Variables< 1 %
- TimeDelay Loop Start< 1 %
- Java Snippet Row Splitter< 1 %
- Value Filter Definition (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Database List Tables (Legacy)< 1 %
- Benchmark Start (2 ports)< 1 %
- Wait...< 1 %
- Catch Errors (Generic Ports)< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Variable to Table Row< 1 %Database Connection Table Reader< 1 %Database Looping< 1 %Generic Loop Start< 1 %Recursive Loop Start< 1 %Cell Replacer< 1 %- Column Comparator< 1 %
- Column Name Extractor< 1 %
- Lag Column< 1 %
- Table Validator (Reference)< 1 %
- Reference Column Filter< 1 %
- Pivot< 1 %
- Numeric Binner (PMML)< 1 %
- Set Operator< 1 %
- Color Manager< 1 %
- Parallel Chunk End< 1 %
- DB Connector< 1 %
- DB Column Rename< 1 %
Excel Reader (XLS)< 1 %- List Box Input (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- JSON to Table< 1 %
- R Snippet< 1 %
- Modify Time< 1 %
- Time Generator (legacy)< 1 %
- Time to String (legacy)< 1 %
- List to FlowVariable< 1 %
- Extract Variables (Database)< 1 %
- Inject Variables (Database)< 1 %
Database Connector< 1 %- Line Reader< 1 %
- Fixed Width File Reader< 1 %
- Variable Creator< 1 %
- Loop End< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Scorer< 1 %
- Add Empty Rows< 1 %
- Cell Splitter< 1 %
- Domain Calculator< 1 %
- Row Filter (Labs)< 1 %
- Row Splitter (Labs)< 1 %
- Number Rounder< 1 %
- RowID< 1 %
- List Box Configuration< 1 %
- Column Selection Configuration< 1 %
- Integer Input (legacy)< 1 %
- Integer Widget< 1 %
Container Input (Variable)< 1 %- Python Edit Variable (legacy)< 1 %
- GET Request< 1 %
SAP Reader (Theobald Software)< 1 %- Disturber Node< 1 %
- Date&Time Part Extractor< 1 %
- Remove Empty Rows< 1 %
- RDKit To InChI< 1 %
Views
- This node has no views
Workflows
02_Create_basic_serviceKNIME Hub- 02_Create_basic_serviceKNIME Hub
- 03_Fetch_ChEMBL_Target_DataKNIME Hub
- 1. Database_OperationsKNIME Hub
- 1. Database_OperationsKNIME Hub
- Show all 37 workflows
Links
- How to use a variable in a sql statementby izaychik63 on 2019-09-02forum.knime.com/p/69106
- Read an excel line and use it as input in DB SQL Executorby izaychik63 on 2019-09-23forum.knime.com/p/70777
- combine text in node DB Query Readerby izaychik63 on 2023-12-21forum.knime.com/p/245606
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.