Executes an entered SQL query and returns the result as KNIME data table.
Options
Settings
Input Type Mapping
This tab allows you to define rules to map from database types to KNIME types.
Popular Predecessors
- DB Connector14 %
- Microsoft SQL Server Connector12 %
- DB SQL Executor7 %
- Table Row to Variable Loop Start6 %
- Oracle Connector5 %
- PostgreSQL Connector3 %
- SQLite Connector3 %
- MySQL Connector3 %
- Google BigQuery Connector2 %
DB Writer2 %- Merge Variables2 %
- Table Row to Variable2 %
- DB Query Reader1 %
- Amazon Redshift Connector1 %
- Variable Expressions (legacy)1 %
- Variable Creator1 %
- String Manipulation (Variable)< 1 %
- Snowflake Connector< 1 %
- Hive Connector< 1 %
- Microsoft Access Connector< 1 %
- Excel Writer< 1 %
- DB Loader< 1 %
DB Loader< 1 %- Wait...< 1 %
- Amazon Athena Connector< 1 %
- DB Connection Extractor< 1 %
DB Insert< 1 %Merge Variables< 1 %- CSV Writer< 1 %
DB Table Creator< 1 %- Impala Connector< 1 %
- Extract Context Properties< 1 %
DB Update< 1 %- Value Selection (legacy)< 1 %
CSV Writer< 1 %Loop End< 1 %- DB Query Extractor< 1 %
- Java Edit Variable (simple)< 1 %
- String Configuration< 1 %
- Variable Loop End< 1 %
- Column Expressions (legacy)< 1 %
Parquet Writer< 1 %Flow Variable IF Switch< 1 %CASE Switch Variable (End)< 1 %- Reference Row Filter< 1 %
- Column Resorter< 1 %
Table Row to Variable< 1 %Table Column to Variable< 1 %- CASE Switch Start< 1 %
- Table Validator< 1 %
- Catch Errors (Generic Ports)< 1 %
- End IF< 1 %
- H2 Connector< 1 %
Create Date&Time Range< 1 %- CSV Reader< 1 %
- Path to String< 1 %
Flow Variable End IF< 1 %Table Column to Variable< 1 %Counting Loop Start< 1 %- Duplicate Row Filter< 1 %
Column Rename< 1 %- DB Connection Closer< 1 %
DB Delete (Table)< 1 %- DB Query< 1 %
Excel Reader (XLS)< 1 %Excel Writer (XLS)< 1 %Container Input (Variable)< 1 %- Python Source (legacy)< 1 %
- Run Garbage Collector< 1 %
- Benchmark End (Flow Variable)< 1 %
- Inject Variables (Data)< 1 %
- Counting Loop Start< 1 %
- Concatenate< 1 %
- Joiner< 1 %
- Send Email< 1 %
- Create File/Folder Variables< 1 %
- String to Path (Variable)< 1 %
- Boolean Configuration< 1 %
- Workflow Input< 1 %
- String to Number< 1 %
- Data to Report (BIRT)< 1 %
- Multiple Selection Widget< 1 %
- Python Edit Variable (legacy)< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Try (Data Ports)< 1 %
- Try (Variable Ports)< 1 %
- Active Branch Inverter< 1 %
Create File Name< 1 %- Extract Variables (Data)< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Database Reader< 1 %Table Reader< 1 %- Table Creator< 1 %
- Java Edit Variable< 1 %
- Java Snippet< 1 %
- Chunk Loop Start< 1 %
- Group Loop Start< 1 %
Variable Loop End< 1 %Constant Value Column< 1 %- Column Filter< 1 %
Row Filter (deprecated)< 1 %- GroupBy< 1 %
- Pivot< 1 %
- RowID< 1 %
- Sorter< 1 %
- String Manipulation< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
- Rule Engine Variable< 1 %
CASE Switch Variable (Start)< 1 %- IF Switch< 1 %
- Timer Info< 1 %
- Interactive Table (legacy)< 1 %
- Vertica Connector< 1 %
DB Merge< 1 %- DB Reader< 1 %
- DB Transaction End< 1 %
- DB Transaction Start< 1 %
- DB Table Deleter< 1 %
DB Table Creator< 1 %DB Table Selector< 1 %- TimeDelay Loop Start< 1 %
- Autocomplete Text Widget< 1 %
- Math Formula (Variable)< 1 %
- Date&Time Configuration< 1 %
- Integer Configuration< 1 %
- Single Selection Configuration< 1 %
- Value Selection Configuration< 1 %
- Date&Time Input (legacy)< 1 %
- Integer Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Date&Time Widget< 1 %
- Integer Widget< 1 %
- String Widget< 1 %
- Single Selection Widget< 1 %
- Value Selection Widget< 1 %
Date&Time to String< 1 %- Time Generator (legacy)< 1 %
- Table Row To Variable Run-to-time Loop Start< 1 %
- Catch Errors (Var Ports)< 1 %
- Table Column to Variable< 1 %
- Variable to Table Row< 1 %
Database Connection Table Reader< 1 %- Loop End< 1 %
- Generic Loop Start< 1 %
- CASE Switch End< 1 %
- Empty Table Switch< 1 %
- DB Row Filter< 1 %
- Excel Reader< 1 %
- List Box Configuration (legacy)< 1 %
- List Box Input (legacy)< 1 %
- Text Output Widget (legacy)< 1 %
- Column Selection Widget< 1 %
- Container Input (Variable)< 1 %
- Python Script (legacy)< 1 %
Modify Date< 1 %- DB Row Manipulator< 1 %
- PMML to SQL< 1 %
- DB Delete (Filter)< 1 %
- Interval Loop Start< 1 %
- Variable to Table Column< 1 %
- Parquet Writer< 1 %
- Write To Excel Template (deprecated)< 1 %
- DB Table Exists IF Switch< 1 %
- Table Writer< 1 %
- Column Aggregator< 1 %
- Path to String (Variable)< 1 %
Date&Time Shift< 1 %- Number to String< 1 %
CASE Switch Model (Start)< 1 %- Credentials Configuration< 1 %
Azure Blob Store File Picker< 1 %- Variable Condition Loop End< 1 %
- Transfer Files< 1 %
- Google Cloud Storage Connector< 1 %
- Call Workflow Service< 1 %
- Parallel Chunk End< 1 %
Excel Writer (XLS)< 1 %Database IF Switch< 1 %FTP Connection< 1 %- File Reader< 1 %
- Nominal Row Filter Configuration< 1 %
- Refresh Button Widget< 1 %
Database Writer< 1 %Generic Loop Start< 1 %Joiner< 1 %- DB Query Injector< 1 %
- Double Configuration< 1 %
- URI Port to Variable< 1 %
- Cross Joiner< 1 %
Create Temp Dir< 1 %- Parameterized DB Query Reader< 1 %
- DB GroupBy< 1 %
- Read Excel Sheet Names< 1 %
- Google Sheets Updater< 1 %
- Table View (JavaScript) (legacy)< 1 %
- Credentials Widget< 1 %
- List Box Widget< 1 %
- Benchmark Start< 1 %
Create Directory< 1 %Database SQL Executor< 1 %- Column Selection Configuration< 1 %
- Single Selection (legacy)< 1 %
- Parameter Optimization Loop End< 1 %
- GET Request< 1 %
- Window Loop Start< 1 %
Database Connector< 1 %Table Row To Variable Loop Start< 1 %- Column Combiner< 1 %
CASE Switch Data (End)< 1 %- Create Local Big Data Environment< 1 %
- Date&Time-based Row Filter< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Read Variables< 1 %
- Run Heavy Garbage Collector< 1 %
- Benchmark Start (Flow Variable)< 1 %
Delete Files< 1 %Catch Errors (DB Ports)< 1 %Table Column to Variable< 1 %Database Delete< 1 %Database Query< 1 %Database Table Connector< 1 %Extract Context Properties< 1 %File Reader< 1 %Table Writer< 1 %Interval Loop Start< 1 %- Column List Loop Start< 1 %
Recursive Loop Start< 1 %CASE Switch Model (End)< 1 %CASE Switch Data (Start)< 1 %- Cache< 1 %
- Spark to Hive< 1 %
MySQL Connector< 1 %- DB Column Filter< 1 %
- DB Row Sampler< 1 %
Excel Sheet Appender (XLS)< 1 %- Java Snippet (simple)< 1 %
Tableau Writer (TDE)< 1 %- Integer Slider Configuration< 1 %
- Boolean Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Generic JavaScript View (JavaScript) (legacy)< 1 %
- Boolean Widget< 1 %
- R Source (Table)< 1 %
- R Snippet< 1 %
- Database Connection Closer< 1 %
- Reset on Load< 1 %
- Database Table Exists IF Switch (Flow Variable Output) (Legacy)< 1 %
- Extract Variables (Database)< 1 %
- Model Reader< 1 %
Variable Condition Loop End< 1 %Recursive Loop End (2 ports)< 1 %- Ungroup< 1 %
- Extract Table Dimension< 1 %
- Capture Workflow Start< 1 %
- DB Writer (DB Data)< 1 %
DB Column Rename (deprecated)< 1 %- Empty Table Creator< 1 %
- External Tool< 1 %
Excel Reader (XLS)< 1 %- Create Temp Folder< 1 %
- Column Filter Configuration< 1 %
- Multiple Selections (legacy)< 1 %
- Container Input (File)< 1 %
- Container Input (JSON)< 1 %
String to Date&Time< 1 %
Views
- This node has no views
Workflows
[01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub
00_xplan sf dbconv-insert via xport-AccountKNIME Hub- 0009582-6KNIME Hub
- 01 - Geracao_Analiticos_OperacaoKNIME Hub
- 01_Database_Simple_IO_ExampleKNIME Hub
- Show all 725 workflows
Links
- DB Table Selector does not display all tablesby mlauber71 on 2019-10-18forum.knime.com/p/72723
- Accessing huge Microsoft Access DBby izaychik63 on 2020-03-05forum.knime.com/p/83492
- Failure in Executing Oracle Procedure from DB Query Readerby AnotherFraudUser on 2021-05-02forum.knime.com/p/122486
- Extract Date from postgresql databaseby izaychik63 on 2022-12-12forum.knime.com/p/182982
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.