This node allows custom SQL statements to be executed on the input database. The output port can be used for flow control, to prevent subsequent nodes from executing if one of the statements fails.
Options
Popular Successors
- DB Query Reader14 %
- DB SQL Executor13 %
- DB Writer12 %
- DB Insert11 %
- DB Loader8 %
- DB Table Selector7 %
- DB Connection Closer4 %
- Variable Loop End3 %
- DB Table Creator2 %
- DB Transaction End1 %
- Loop End1 %
- DB Query< 1 %
- DB Update< 1 %
- DB Merge< 1 %
- Send Email< 1 %
- Microsoft SQL Server Connector< 1 %
- CASE Switch End< 1 %
- PostgreSQL Connector< 1 %
Flow Variable End IF< 1 %CASE Switch Variable (End)< 1 %- DB Delete (Table)< 1 %
- Variable to Table Row< 1 %
- Timer Info< 1 %
- DB Reader< 1 %
- Date&Time to String< 1 %
- DB GroupBy< 1 %
- Math Formula< 1 %
- Excel Writer< 1 %
- Create Temp Folder< 1 %
- CSV Writer< 1 %
- Merge Variables< 1 %
- Excel Reader< 1 %
- Variable Creator< 1 %
Variable Condition Loop End< 1 %Column Rename< 1 %- DB Table Remover< 1 %
- Python Source (legacy)< 1 %
- Benchmark End (Flow Variable)< 1 %
- Wait...< 1 %
- SQLite Connector< 1 %
DB Loader< 1 %- Transfer Files< 1 %
Table Row to Variable< 1 %File Reader< 1 %- CASE Switch Start< 1 %
- Variable Expressions< 1 %
- Python Edit Variable (legacy)< 1 %
- CSV Reader< 1 %
Loop End< 1 %- Variable Condition Loop End< 1 %
- Generic Loop Start< 1 %
- Column Filter< 1 %
- GroupBy< 1 %
- String Manipulation< 1 %
- String Manipulation (Multi Column)< 1 %
- Spark to Hive< 1 %
- Capture Workflow End< 1 %
- Parallel Chunk Start< 1 %
- DB Connector< 1 %
- POST Request< 1 %
- Delete Files (legacy)< 1 %
- String to URI< 1 %
- Catch Errors (Generic Ports)< 1 %
- Catch Errors (Var Ports)< 1 %
- Inject Variables (Data)< 1 %
Database Reader< 1 %- File Reader< 1 %
- Table Creator< 1 %
- Java Snippet< 1 %
- Counting Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
Variable Loop End< 1 %Row Filter (deprecated)< 1 %- Missing Value< 1 %
- Rule-based Row Filter< 1 %
- End IF< 1 %
- MySQL Connector< 1 %
- DB Connection Table Writer< 1 %
- DB Delete (Filter)< 1 %
- DB Row Manipulator< 1 %
- DB Joiner< 1 %
- DB Transaction Start< 1 %
- DB Query Injector< 1 %
DB Table Creator< 1 %- SMB Connector< 1 %
- Delete Files/Folders< 1 %
- String to Path (Variable)< 1 %
Transfer Files< 1 %- Credentials Input (legacy)< 1 %
- Logger Option< 1 %
- Create Date&Time Range< 1 %
Catch Errors (DB Ports)< 1 %- Variable to Table Column< 1 %
List Files< 1 %Merge Variables< 1 %- DB Pivot< 1 %
Excel Reader (XLS)< 1 %- String to Date&Time< 1 %
Flow Variable IF Switch< 1 %- FTP Connection (legacy)< 1 %
Variable to Table Row< 1 %- Double to Integer< 1 %
- String Manipulation (Variable)< 1 %
Excel Sheet Appender (XLS)< 1 %- Java Snippet (simple)< 1 %
- Table View (JavaScript)< 1 %
- GET Request< 1 %
- Try (Variable Ports)< 1 %
- Chunk Loop Start< 1 %
- Column Rename (Regex)< 1 %
Joiner< 1 %CASE Switch Model (Start)< 1 %CASE Switch Data (End)< 1 %- Amazon Redshift Connector< 1 %
- Parallel Chunk End< 1 %
- Oracle Connector< 1 %
- DB Column Filter< 1 %
- Column Expressions< 1 %
- String Input (legacy)< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Write Variables< 1 %
- SSH Connection (legacy)< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
- Active Branch Inverter< 1 %
- Table Column to Variable< 1 %
Table Row To Variable Loop Start< 1 %Variable to Table Row< 1 %CSV Reader< 1 %Database Table Connector< 1 %Database Writer< 1 %Database Table Selector< 1 %Database Connector< 1 %Simple File Reader< 1 %- Table Reader< 1 %
Table Reader< 1 %- Java Edit Variable< 1 %
- Concatenate< 1 %
Column Appender< 1 %- Constant Value Column< 1 %
- Create Table Structure< 1 %
Row Splitter (deprecated)< 1 %- Save Workflow< 1 %
Parquet Reader< 1 %- HDFS Connection (legacy)< 1 %
MySQL Connector< 1 %- Vertica Connector< 1 %
- DB Type Mapper< 1 %
- DB Row Filter< 1 %
- DB Query Extractor< 1 %
- Empty Table Creator< 1 %
- Model Loop End< 1 %
Excel Reader (XLS)< 1 %Excel Writer (XLS)< 1 %Excel Writer (XLS)< 1 %- Java Edit Variable (simple)< 1 %
- Date&Time Configuration< 1 %
- Text Output (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- String Widget< 1 %
Python Script (1⇒1)< 1 %- Python Script (legacy)< 1 %
- R Source (Table)< 1 %
Views
- This node has no views
Workflows
01 Practicing with Traditional DatabasesKNIME Hub- 01 Practicing with Traditional Databases - SolutionKNIME Hub
- 01 Practicing with Traditional Databases - SolutionKNIME Hub
- 01 Practicing with Traditional Databases - SolutionKNIME Hub
- 01 Practicing with Traditional Databases - SolutionKNIME Hub
- Show all 348 workflows
Links
- DB Query Reader can’t support multiple queriesby izaychik63 on 2022-05-26forum.knime.com/p/158438
- Database MERGE with DB Query Readerby izaychik63 on 2024-09-30forum.knime.com/p/270636
- Inserting values to JSONB columns in PostgreSQLby armingrudd on 2022-07-07forum.knime.com/p/162546
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.