Modifies the SQL query that defines the incoming DB Data table. The incoming SQL query is represented by the place holder #table# and will be replaced during execute thus creating a sub-query. The resulting SQL query defines the new DB Data table at the out-port.
Options
Popular Successors
- DB Reader28 %
- DB Query17 %
- DB GroupBy17 %
- DB Joiner14 %
- DB Row Filter8 %
- DB Column Filter3 %
- DB Concatenate2 %
- DB Connection Table Writer2 %
- DB Query Extractor2 %
- Parameterized DB Query Reader1 %
- DB Column Rename1 %
- DB Pivot< 1 %
- DB Connection Extractor< 1 %
- DB Sorter< 1 %
- DB Row Sampling< 1 %
- CASE Switch End< 1 %
- DB Query Reader< 1 %
- DB Data Spec Extractor< 1 %
- DB to Spark< 1 %
- Hive to Spark< 1 %
- DB Writer< 1 %
- DB Insert< 1 %
- DB Type Mapper< 1 %
- DB Table Creator< 1 %
- DB Table Selector< 1 %
- Rule Engine< 1 %
- DB Looping< 1 %
- String Manipulation (Variable)< 1 %
- DB Apply-Binner< 1 %
- DB Partitioning< 1 %
- DB DISTINCT< 1 %
Variable Loop End< 1 %Joiner< 1 %- DB Numeric-Binner< 1 %
- DB Merge< 1 %
- Variable Expressions< 1 %
- Impala to Spark< 1 %
- DB Column Rename (Regex)< 1 %
- DB SQL Executor< 1 %
- File Reader< 1 %
- Loop End< 1 %
- CASE Switch Start< 1 %
- Inject Variables (Database)< 1 %
- Extract Context Properties< 1 %
- Configurable End IF/CASE< 1 %
- DB Auto-Binner< 1 %
- Date&Time Input (legacy)< 1 %
- Active Branch Inverter< 1 %
- DB Loader< 1 %
- Try (Data Ports)< 1 %
- Table Manipulator< 1 %
- DB Delete (Table)< 1 %
Database Reader< 1 %DB Table Creator< 1 %Excel Reader (XLS)< 1 %- DB Connection Closer< 1 %
Variable to Table Row< 1 %Loop End (2 ports)< 1 %- GroupBy< 1 %
CASE Switch Model (End)< 1 %- PostgreSQL Connector< 1 %
- Google Sheets Updater< 1 %
CSV Writer< 1 %Database Writer< 1 %Model Writer< 1 %Loop End< 1 %- Column Filter< 1 %
- DB Update< 1 %
- Container Input (Table)< 1 %
- R Snippet< 1 %
- Data to Report (BIRT)< 1 %
- Catch Errors (Generic Ports)< 1 %
Database SQL Executor< 1 %Database Connector< 1 %- Send Email< 1 %
- Explorer Browser< 1 %
- Path to String (Variable)< 1 %
Views
- This node has no views
Workflows
02_Database_Advanced_ExampleKNIME Hub- 02_Database_Advanced_ExampleKNIME Hub
- 02_Database_Advanced_ExampleKNIME Hub
- 02_Database_Advanced_ExampleKNIME Hub
- 02_DB_InDB_ProcessingKNIME Hub
- Show all 163 workflows
Links
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.