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 Predecessors
- DB SQL Executor13 %
- Microsoft SQL Server Connector9 %
- DB Writer8 %
- DB Connector5 %
- DB Loader4 %
- DB Insert4 %
- Table Row to Variable Loop Start3 %
- MySQL Connector3 %
- DB Table Creator3 %
- PostgreSQL Connector2 %
- SQLite Connector2 %
- DB Connection Extractor2 %
- CSV Writer2 %
- DB Table Remover2 %
- Merge Variables2 %
- Oracle Connector2 %
- Table Row to Variable1 %
- Microsoft Access Connector1 %
- Excel Writer1 %
- DB Query Extractor1 %
- DB Transaction Start1 %
- String Manipulation (Variable)1 %
- Wait...< 1 %
- Variable Creator< 1 %
- DB Query Reader< 1 %
- Amazon Redshift Connector< 1 %
- Variable Loop End< 1 %
- DB Update< 1 %
- GroupBy< 1 %
- DB Merge< 1 %
- Variable Expressions< 1 %
- DB Table Selector< 1 %
DB Table Creator< 1 %Excel Writer (XLS)< 1 %- Excel Reader< 1 %
- Java Edit Variable< 1 %
- DB Connection Table Writer< 1 %
- DB Connection Closer< 1 %
- Snowflake Connector< 1 %
- Try (Variable Ports)< 1 %
- H2 Connector< 1 %
- Amazon Athena Connector< 1 %
- Column Filter< 1 %
- DB Reader< 1 %
- CASE Switch Start< 1 %
Loop End< 1 %- Hive Connector< 1 %
- String Input (legacy)< 1 %
- CASE Switch End< 1 %
- Vertica Connector< 1 %
Excel Reader (XLS)< 1 %- Loop End< 1 %
- Duplicate Row Filter< 1 %
- Row Filter< 1 %
CASE Switch Variable (Start)< 1 %- Empty Table Switch< 1 %
- Joiner< 1 %
Flow Variable End IF< 1 %Table Row to Variable< 1 %- Column Resorter< 1 %
- Constant Value Column< 1 %
Column Rename< 1 %- Java Edit Variable (simple)< 1 %
- Double to Integer< 1 %
- End IF< 1 %
Parquet Writer< 1 %- DB Delete (Filter)< 1 %
Database Writer< 1 %- String to Number< 1 %
- Rule Engine Variable< 1 %
- Send Email< 1 %
- String Configuration< 1 %
- String to Date&Time< 1 %
- Inject Variables (Data)< 1 %
- Concatenate< 1 %
Merge Variables< 1 %- Google BigQuery Connector< 1 %
- DB Transaction End< 1 %
- String to Path (Variable)< 1 %
- Python Script (legacy)< 1 %
Flow Variable IF Switch< 1 %- Breakpoint< 1 %
Table Column to Variable< 1 %Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %- Cross Joiner< 1 %
- Rule Engine< 1 %
- Impala Connector< 1 %
- Integer Configuration< 1 %
- Extract Context Properties< 1 %
- Table Writer< 1 %
- Table Manipulator< 1 %
CASE Switch Variable (End)< 1 %- Transfer Files< 1 %
- String Widget< 1 %
- Workflow Service Input< 1 %
- Write To Excel Template (deprecated)< 1 %
- Active Branch Inverter< 1 %
Table Column to Variable< 1 %Generic Loop Start< 1 %- String Manipulation< 1 %
- DB Query< 1 %
- Date&Time Widget< 1 %
Python Script (1⇒1)< 1 %- Python Edit Variable (legacy)< 1 %
Variable Condition Loop End< 1 %- Create Local Big Data Environment< 1 %
Transfer Files< 1 %- Group Loop Start< 1 %
- Counting Loop Start< 1 %
- DB Sorter< 1 %
- Column Auto Type Cast< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Extract Variables (Data)< 1 %
Variable Loop End< 1 %- Missing Value< 1 %
- Sorter< 1 %
- Rule-based Row Filter< 1 %
DB Loader< 1 %- Column Expressions< 1 %
- Math Formula< 1 %
- Math Formula (Variable)< 1 %
- POST Request< 1 %
- Date&Time to String< 1 %
- Table Column to Variable< 1 %
- Java Snippet< 1 %
- Column Renamer (Dictionary)< 1 %
- IF Switch< 1 %
- Path to String (Variable)< 1 %
- PUT Request< 1 %
- Capture Workflow Start< 1 %
- Extract Table Dimension< 1 %
- DB Delete (Table)< 1 %
- DB Table Exists IF Switch< 1 %
- Reference DB Table Exists IF Switch< 1 %
- Configurable IF/CASE Switch< 1 %
- Parquet Writer< 1 %
- GET Request< 1 %
- Delete Files (legacy)< 1 %
- Catch Errors (Generic Ports)< 1 %
Table Writer< 1 %- Chunk Loop Start< 1 %
Joiner< 1 %- Integer Widget< 1 %
- Catch Errors (Data Ports)< 1 %
- RowID< 1 %
- Java Snippet (simple)< 1 %
- List Files/Folders< 1 %
- Benchmark Start (Flow Variable)< 1 %
- Parallel Chunk End< 1 %
Microsoft SQL Server Connector< 1 %- Python Source (legacy)< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Recursive Loop End< 1 %
- Top k Row Filter< 1 %
CASE Switch Model (Start)< 1 %Table Row to Variable< 1 %- Catch Errors (Var Ports)< 1 %
Counting Loop Start< 1 %Excel Writer (XLS)< 1 %- Date&Time Configuration< 1 %
- Generic Run-for-time Loop Start< 1 %
- Variable to Table Row< 1 %
- Destroy Spark Context< 1 %
- Credentials Configuration< 1 %
- Local File Browser Configuration< 1 %
- Extract URI Info< 1 %
- Upload (legacy)< 1 %
Variable to Table Row< 1 %CSV Writer< 1 %Database Connector< 1 %Concatenate (Optional in)< 1 %- Number to String< 1 %
- Round Double< 1 %
- PMML to SQL< 1 %
ORC Writer< 1 %Parquet Writer< 1 %- Spark to Hive< 1 %
- Date&Time Input (legacy)< 1 %
- Integer Input (legacy)< 1 %
Database SQL Executor< 1 %- CSV Reader< 1 %
- File Reader< 1 %
- Table Reader< 1 %
- Table Creator< 1 %
- Column Appender< 1 %
- Lag Column< 1 %
- Table Validator (Reference)< 1 %
- Reference Row Filter< 1 %
- ORC Writer< 1 %
- DB Type Mapper< 1 %
- Parameterized DB Query Reader< 1 %
- SAS7BDAT Reader< 1 %
- Compress Files/Folder< 1 %
- Create File/Folder Variables< 1 %
- Google Sheets Reader< 1 %
- Value Selection Configuration< 1 %
- Double Widget< 1 %
- Single Selection Widget< 1 %
- JSON Path< 1 %
JSON Writer< 1 %- R Source (Table)< 1 %
- R Snippet< 1 %
- Date&Time Shift< 1 %
- Modify Time Zone< 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 326 workflows
Links
- DB Query Reader can’t support multiple queriesby izaychik63 on 2022-05-26forum.knime.com/p/158438
- 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.