This node extracts the SQL query from the input DB Data port and creates a flow variable and a KNIME data table containing the query.
Options
Popular Successors
- DB SQL Executor11 %
- DB Query Reader5 %
DB Loader3 %Merge Variables3 %- DB Query Injector3 %
- Rule-based Row Filter3 %
CSV Writer2 %- DB Query2 %
- String Manipulation2 %
- Merge Variables2 %
- Parameterized DB Query Reader2 %
- Excel Writer2 %
- Constant Value Column2 %
- Variable to Table Row1 %
- Variable Loop End1 %
- Oracle Connector1 %
- DB Connection Extractor1 %
- DB Writer1 %
- Table Row to Variable1 %
- CSV Writer1 %
Table Writer1 %- Concatenate1 %
- Joiner1 %
- String Manipulation (Variable)1 %
- Rule Engine1 %
- Interactive Table (legacy)1 %
- DB Connector1 %
- DB Insert1 %
- DB Reader1 %
DB Table Creator1 %- DB Table Creator1 %
- DB Table Selector1 %
- Variable Expressions (legacy)1 %
Excel Sheet Appender (XLS)1 %- Table View (JavaScript)1 %
- Data to Report (BIRT)1 %
Interval Loop Start< 1 %- Chunk Loop Start< 1 %
- Cache< 1 %
- Color Manager< 1 %
- String Input (legacy)< 1 %
Flow Variable IF Switch< 1 %- Table Writer< 1 %
Variable Loop End< 1 %- Column Appender< 1 %
- Nominal Value Row Splitter< 1 %
- Capture Workflow End< 1 %
- DB Row Filter< 1 %
- String to JSON< 1 %
- Python Edit Variable (legacy)< 1 %
- Date&Time to String< 1 %
Table Row to Variable< 1 %Table Row to Variable< 1 %- File Reader< 1 %
- Java Edit Variable< 1 %
Column Appender< 1 %- Cross Joiner< 1 %
Column Rename< 1 %- Shape Manager< 1 %
- DB Delete (Table)< 1 %
- DB Transaction Start< 1 %
Table to HTML< 1 %- GroupBy Bar Chart (JFreeChart)< 1 %
Flow Variable End IF< 1 %- Table to String< 1 %
- Breakpoint< 1 %
Database SQL Executor< 1 %- CSV Reader< 1 %
- Java Snippet< 1 %
Loop End< 1 %Counting Loop Start< 1 %- Group Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- Number to String< 1 %
- Column Aggregator< 1 %
- Column Filter< 1 %
- Nominal Value Row Filter< 1 %
Row Filter (deprecated)< 1 %- GroupBy< 1 %
Joiner< 1 %- Table Manipulator< 1 %
- Table Transposer< 1 %
- Statistics< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Scatter Plot (legacy)< 1 %
Parquet Writer< 1 %- DB Connection Closer< 1 %
- DB Loader< 1 %
- DB Update< 1 %
- Math Formula (Multi Column)< 1 %
- Math Formula (Variable)< 1 %
Excel Writer (XLS)< 1 %- Send to Power BI< 1 %
Tableau Writer (Hyper)< 1 %- Line Plot (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Table to JSON< 1 %
- Python Source (legacy)< 1 %
- String to Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
Views
- This node has no views
Workflows
1. Database_OperationsKNIME Hub- 1. Database_OperationsKNIME Hub
- 1. Database_OperationsKNIME Hub
- 1. Database_OperationsKNIME Hub
- 1. Database_OperationsKNIME Hub
- Show all 28 workflows
Links
- No links available
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.