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.
The place holder in brackets for table name and table column must be replaced, while the possible value place holder enclosed in hashes must not be edit and will be resolved during execution.
If the optional input is connected the database connection information is taken from the port, otherwise you need to specify the connection information in the dialog.
Make sure you have your vendor-specific database driver registered in the KNIME preference page (section Database Driver).
Options
Popular Predecessors
- GroupBy11 %
- Excel Reader9 %
- Rule-based Row Filter7 %
- Row Filter5 %
- Joiner5 %
- Value Counter4 %
Database Reader4 %- Duplicate Row Filter4 %
- CSV Reader3 %
- Column Filter3 %
Database Looping3 %- Table Creator2 %
- Rule Engine2 %
- Table Row to Variable1 %
- Number to String1 %
- Set Operator1 %
- Column Resorter1 %
- Rule-based Row Splitter< 1 %
Amazon Redshift Connector< 1 %- String Manipulation< 1 %
SQLite Connector< 1 %- Concatenate< 1 %
Joiner< 1 %Column Rename< 1 %- Ungroup< 1 %
- Math Formula< 1 %
PostgreSQL Connector< 1 %- String to Number< 1 %
- Date&Time-based Row Filter< 1 %
- Row Sampling< 1 %
- Create Date&Time Range< 1 %
- Top k Row Filter< 1 %
- Reference Row Filter< 1 %
MySQL Connector< 1 %Table Reader< 1 %- Chunk Loop Start< 1 %
- Round Double< 1 %
- End IF< 1 %
Excel Reader (XLS)< 1 %Table Row To Variable Loop Start< 1 %- Reference Row Splitter< 1 %
- Cache< 1 %
Counting Loop Start< 1 %- DB Reader< 1 %
Database Connector< 1 %Number To String< 1 %- Partitioning< 1 %
- File Reader< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Sorter< 1 %
- String Replacer< 1 %
Excel Reader (XLS)< 1 %- DB Query Reader< 1 %
File Reader< 1 %- Pivot< 1 %
Amazon Athena Connector< 1 %Database Column Filter< 1 %- Row Splitter< 1 %
Microsoft SQL Server Connector< 1 %- Java Snippet (simple)< 1 %
- Column Auto Type Cast< 1 %
- Python Script (legacy)< 1 %
- Group Loop Start< 1 %
- Double to Integer< 1 %
- Nominal Value Row Filter< 1 %
- Rank< 1 %
- DB Insert< 1 %
Table Column to Variable< 1 %CSV Reader< 1 %Database Table Connector< 1 %SQL Extract< 1 %- Case Converter< 1 %
- Column Splitter< 1 %
- Empty Table Switch< 1 %
Excel Reader (XLS)< 1 %- List Box Input (legacy)< 1 %
- Column Rename (Regex)< 1 %
Flow Variable IF Switch< 1 %Database Drop Table< 1 %Recursive Loop Start< 1 %- Column Comparator< 1 %
- Constant Value Column< 1 %
Double To Int< 1 %- Missing Value< 1 %
- Parallel Chunk End< 1 %
- Empty Table Creator< 1 %
- Date&Time Difference< 1 %
- String to Date&Time< 1 %
Database GroupBy< 1 %- IF Switch< 1 %
- Parquet Reader< 1 %
- Modify Time< 1 %
- String to Number (PMML)< 1 %
Database Delete< 1 %Database Row Filter< 1 %CASE Switch Variable (End)< 1 %- Value Filter (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Data Generator< 1 %
- String Input (legacy)< 1 %
- Window Loop Start< 1 %
Database SQL Executor< 1 %Database Table Selector< 1 %- Java Edit Variable< 1 %
Cell Splitter< 1 %- Cell Splitter By Position< 1 %
Column Appender< 1 %- HiLite Row Splitter< 1 %
- Regex Split< 1 %
- String Manipulation (Variable)< 1 %
- Table Transposer< 1 %
Vertica Connector< 1 %H2 Connector< 1 %XLS Reader< 1 %- Python Source (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %List Files< 1 %- Column Expressions< 1 %
- Wait...< 1 %
Database Query< 1 %Database Update< 1 %Database Table Creator< 1 %String To Number< 1 %- Interactive HiLite Collector< 1 %
Merge Variables< 1 %- Molecule Type Cast< 1 %
- Column Filter (legacy)< 1 %
- Date&Time to String< 1 %
- Mask Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Random Numbers Generator< 1 %
Line Reader< 1 %Variable Loop End< 1 %- Nominal Value Row Splitter< 1 %
- Voting Loop End< 1 %
- Integer Input (legacy)< 1 %
- Column Aggregator< 1 %
- Decompress Files< 1 %
- Benchmark Start< 1 %
- MarvinSketch< 1 %
- MolConverter< 1 %
- Binary Objects to Strings< 1 %
- Breakpoint< 1 %
- Inject Variables (Database)< 1 %
Table Row to Variable< 1 %Variable to Table Row< 1 %Database Connection Table Reader< 1 %Database Joiner< 1 %Database Writer< 1 %Database Auto-Binner< 1 %Parameterized Database Query< 1 %- Java Snippet< 1 %
Loop End< 1 %- Column List Loop Start< 1 %
Generic Loop Start< 1 %- Column Combiner< 1 %
- Category to Number< 1 %
- Cross Joiner< 1 %
- Missing Value Column Filter< 1 %
- RowID< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
CASE Switch Variable (Start)< 1 %- Extract Table Spec< 1 %
Hive Connector< 1 %- Parallel Chunk Start< 1 %
- OpenBabel< 1 %
Excel Writer (XLS)< 1 %Dictionary tagger< 1 %Python Script (2⇒1)< 1 %Python Source< 1 %- R Snippet< 1 %
- Date&Time Shift< 1 %
- Moving Aggregator< 1 %
- Preset Date/Time (legacy)< 1 %
- CIR< 1 %
- FileToTable< 1 %
- Database List Tables (Legacy)< 1 %
- Chunk Loop Run-for-time Loop Start< 1 %
- Read Variables< 1 %
- GPCRDB Protein information< 1 %
- Copy/Move Files (legacy)< 1 %
- Unzip Files (legacy)< 1 %
- Extract Variables (Database)< 1 %
Database Sorter< 1 %SQL Inject< 1 %Database Column Rename< 1 %Database Pivot< 1 %- Feature Selection Loop Start (1:1)< 1 %
Loop End (2 ports)< 1 %Recursive Loop End< 1 %- PNN Learner (DDA)< 1 %
Scorer< 1 %- Add Empty Rows< 1 %
- Cell Splitter< 1 %
CASE Switch Model (End)< 1 %- Extract Table Dimension< 1 %
- PMML to SQL< 1 %
Hive Loader (legacy)< 1 %Impala Connector< 1 %- SDF Reader< 1 %
- Parameterized DB Query Reader< 1 %
- Counter Generation< 1 %
- TimeDelay Loop End< 1 %
- TimeDelay Loop Start< 1 %
- Generic Web Service Client< 1 %
- Java Edit Variable (simple)< 1 %
- Java Snippet Row Filter< 1 %
- Integer Configuration< 1 %
- List Box Configuration< 1 %
- Credentials Input (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Double Input (legacy)< 1 %
- File Chooser (legacy)< 1 %
- File Upload (legacy)< 1 %
- Table View (JavaScript)< 1 %
- List Box Widget< 1 %
- Container Input (Table)< 1 %
- JSON Path< 1 %
JSON Reader< 1 %Python Script (1⇒1)< 1 %- GET Request< 1 %
- Date&Time to legacy Date&Time< 1 %
- Time Difference (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- URL Extractor< 1 %
Database Numeric-Binner< 1 %- Number to Category (Apply)< 1 %
- XML to PMML< 1 %
- Merge Variables< 1 %
- Microsoft SQL Server Connector< 1 %
- DB Writer< 1 %
- Random Number Assigner (Apache)< 1 %
- Model Loop End< 1 %
- Boosting Learner Loop Start< 1 %
Extract Date&Time Fields< 1 %
Views
- This node has no views
Workflows
Links
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.