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 Connector8 %
- DB Writer8 %
- DB Loader6 %
- DB Connector4 %
- DB Insert4 %
- Table Row to Variable Loop Start3 %
- PostgreSQL Connector2 %
- MySQL Connector2 %
- DB Connection Extractor2 %
- DB Table Creator2 %
- DB Table Remover2 %
- DB Query Extractor1 %
- Oracle Connector1 %
- Merge Variables1 %
- Table Row to Variable1 %
- DB Update1 %
- CSV Writer1 %
- SQLite Connector< 1 %
- Microsoft Access Connector< 1 %
- DB Query Reader< 1 %
- Excel Writer< 1 %
- Wait...< 1 %
DB Table Creator< 1 %- GroupBy< 1 %
- DB Transaction Start< 1 %
Excel Writer (XLS)< 1 %- Variable Loop End< 1 %
- Amazon Redshift Connector< 1 %
- String Manipulation (Variable)< 1 %
- Snowflake Connector< 1 %
Row Filter (deprecated)< 1 %- Amazon Athena Connector< 1 %
- Variable Creator< 1 %
Loop End< 1 %- DB Connection Table Writer< 1 %
- String Input (legacy)< 1 %
- DB Merge< 1 %
Excel Reader (XLS)< 1 %- Table Column to Variable< 1 %
- Loop End< 1 %
- Variable Expressions< 1 %
- Joiner< 1 %
- Table Manipulator< 1 %
- Column Filter< 1 %
CASE Switch Variable (Start)< 1 %- Empty Table Switch< 1 %
- DB Table Selector< 1 %
- Excel Reader< 1 %
Flow Variable End IF< 1 %- Vertica Connector< 1 %
- Java Edit Variable (simple)< 1 %
- CASE Switch End< 1 %
- Try (Variable Ports)< 1 %
- Java Edit Variable< 1 %
- Constant Value Column< 1 %
Parquet Writer< 1 %Database Writer< 1 %Column Rename< 1 %- Inject Variables (Data)< 1 %
Merge Variables< 1 %- String to Path (Variable)< 1 %
- DB Delete (Filter)< 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 %- String to Number< 1 %
- Column Resorter< 1 %
- Google BigQuery Connector< 1 %
- H2 Connector< 1 %
- Integer Configuration< 1 %
- Extract Context Properties< 1 %
- Table Writer< 1 %
CASE Switch Variable (End)< 1 %- Transfer Files< 1 %
- String Widget< 1 %
- Workflow Service Input< 1 %
- Catch Errors (Generic Ports)< 1 %
Table Column to Variable< 1 %Generic Loop Start< 1 %- Concatenate< 1 %
- Cross Joiner< 1 %
- String Manipulation< 1 %
- Impala Connector< 1 %
- DB Connection Closer< 1 %
- DB Query< 1 %
- String Configuration< 1 %
- Date&Time Widget< 1 %
Python Script (1⇒1)< 1 %Variable Condition Loop End< 1 %- Create Local Big Data Environment< 1 %
Transfer Files< 1 %- Group Loop Start< 1 %
- DB Sorter< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Extract Variables (Data)< 1 %
Table Row to Variable< 1 %Variable Loop End< 1 %- Double to Integer< 1 %
- Missing Value< 1 %
- Sorter< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
- Rule Engine Variable< 1 %
- Send Email< 1 %
- Hive Connector< 1 %
DB Loader< 1 %- DB Reader< 1 %
- Column Expressions< 1 %
- Math Formula< 1 %
- Math Formula (Variable)< 1 %
- Date&Time Input (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
- POST Request< 1 %
- Date&Time to String< 1 %
- String to Date&Time< 1 %
- CSV Reader< 1 %
- Java Snippet< 1 %
- Column Renamer (Dictionary)< 1 %
- Duplicate Row Filter< 1 %
- CASE Switch Start< 1 %
- End IF< 1 %
- IF Switch< 1 %
- DB Transaction End< 1 %
- Path to String (Variable)< 1 %
- Python Script (legacy)< 1 %
- PUT Request< 1 %
- Counting Loop Start< 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 %
- Write To Excel Template (deprecated)< 1 %
- Active Branch Inverter< 1 %
- Column Auto Type Cast< 1 %
- Parquet Writer< 1 %
- GET Request< 1 %
- Create Databricks Environment< 1 %
- Delete Files (legacy)< 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 %
- Number Rounder< 1 %
- PMML to SQL< 1 %
ORC Writer< 1 %Parquet Writer< 1 %- Spark to Hive< 1 %
- Integer Input (legacy)< 1 %
Database SQL Executor< 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 349 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.