This node takes a DB Connection as input and allows to select a table or view from within the connected
database. The node outputs a DB Data object which contains the database connection information as well
as a database query that defines the data in the database.
In addition, this node allows to enter a customized SELECT statement which is then propagated to
all connected nodes.
Options
Popular Successors
- DB Reader39 %
- DB Joiner18 %
- DB Query10 %
- DB Row Filter8 %
- DB Column Filter5 %
- DB GroupBy4 %
- Parameterized DB Query Reader4 %
- DB Looping2 %
- DB Concatenate1 %
- DB Query Extractor< 1 %
- DB Connection Table Writer< 1 %
- DB Pivot< 1 %
- DB Row Sampling< 1 %
- DB Connection Extractor< 1 %
- DB Column Rename< 1 %
- DB Sorter< 1 %
- DB Type Mapper< 1 %
- DB Data Spec Extractor< 1 %
- CASE Switch Start< 1 %
- DB Column Rename (Regex)< 1 %
- DB Table Selector< 1 %
- DB SQL Executor< 1 %
- DB Query Reader< 1 %
- Variable to Table Row< 1 %
- CSV Reader< 1 %
- Hive to Spark< 1 %
- Joiner< 1 %
- CASE Switch End< 1 %
- DB Connection Closer< 1 %
- DB Loader< 1 %
- DB Numeric-Binner< 1 %
- DB Partitioning< 1 %
Row Filter (deprecated)< 1 %- Impala to Spark< 1 %
- DB Writer< 1 %
- Try (Variable Ports)< 1 %
- Active Branch Inverter< 1 %
- DB to Spark< 1 %
- Capture Workflow End< 1 %
- DB Merge< 1 %
- DB Auto-Binner< 1 %
- DB Extract Table Dimension< 1 %
- Catch Errors (Generic Ports)< 1 %
- Catch Errors (Var Ports)< 1 %
- Variable Loop End< 1 %
- String Manipulation (Variable)< 1 %
- Save Workflow< 1 %
- Microsoft SQL Server Connector< 1 %
- DB Connector< 1 %
- DB Delete (Filter)< 1 %
- DB Insert< 1 %
- DB Update< 1 %
- DB Table Remover< 1 %
- DB Table Creator< 1 %
- Python Source (legacy)< 1 %
- Create Date&Time Range< 1 %
- Workflow Service Output< 1 %
- Snowflake H2O MOJO Predictor (Classification)< 1 %
- String Manipulation< 1 %
- DB Delete (Table)< 1 %
- Math Formula< 1 %
- Excel Reader< 1 %
- Refresh Button Widget< 1 %
- Extract Variables (Database)< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %- Table Row to Variable< 1 %
- ARFF Reader< 1 %
Database Column Filter< 1 %Database Connection Table Reader< 1 %- Column List Loop Start< 1 %
- Reference Row Filter< 1 %
- Timer Info< 1 %
Microsoft SQL Server Connector< 1 %- DB Apply-Binner< 1 %
Excel Reader (XLS)< 1 %- Date&Time Configuration< 1 %
- String Configuration< 1 %
Database IF Switch< 1 %- Variable to Table Column< 1 %
- Extract Variables (Data)< 1 %
Table Row to Variable< 1 %Database Table Connector< 1 %Database Reader< 1 %Database SQL Executor< 1 %- Table Reader< 1 %
Table Reader< 1 %Counting Loop Start< 1 %- Table Row to Variable Loop Start< 1 %
- k-Means< 1 %
- Concatenate< 1 %
- Duplicate Row Filter< 1 %
- Column Filter< 1 %
- Reference Column Filter< 1 %
Column Rename< 1 %- Extract Table Dimension< 1 %
- Send Email< 1 %
- Interactive Table (legacy)< 1 %
- MySQL Connector< 1 %
- PostgreSQL Connector< 1 %
- SQLite Connector< 1 %
DB Table Creator< 1 %- Send to Power BI< 1 %
- List Box Configuration< 1 %
- JSON to Table< 1 %
- Python Edit Variable (legacy)< 1 %
- Modify Date< 1 %
Views
- This node has no views
Workflows
[ON] PEX ROTINAS 2024KNIME Hub- 00 Main MenuKNIME Hub
- 00 Main MenuKNIME Hub
- 00 Send Reporting_vMediumKNIME Hub
- 00_Getting_started_with_SnowflakeKNIME Hub
- Show all 2267 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.