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 Predecessors
- DB Connector12 %
- SQLite Connector10 %
- Microsoft SQL Server Connector9 %
- MySQL Connector7 %
- Microsoft Access Connector6 %
- Oracle Connector6 %
- PostgreSQL Connector6 %
- DB SQL Executor4 %
- Table Row to Variable Loop Start3 %
- Snowflake Connector2 %
- Google BigQuery Connector2 %
- Impala Connector2 %
- Merge Variables2 %
- Table Row to Variable2 %
- Amazon Redshift Connector2 %
- Variable Creator1 %
- DB Connection Extractor1 %
- DB Loader< 1 %
- Hive Connector< 1 %
- DB Table Creator< 1 %
- Create Databricks Environment< 1 %
- Amazon Athena Connector< 1 %
- String Manipulation (Variable)< 1 %
- H2 Connector< 1 %
- CSV Writer< 1 %
- DB Insert< 1 %
- Table Column to Variable< 1 %
- DB Writer< 1 %
- CASE Switch Start< 1 %
DB Table Creator< 1 %- Variable Expressions< 1 %
- DB Connection Closer< 1 %
- DB Transaction Start< 1 %
- String Configuration< 1 %
- DB Table Selector< 1 %
- Generic Loop Start< 1 %
- GroupBy< 1 %
- DB Row Filter< 1 %
Flow Variable IF Switch< 1 %- DB Connection Table Writer< 1 %
- DB Query< 1 %
- DB GroupBy< 1 %
- Group Loop Start< 1 %
- DB Joiner< 1 %
- Excel Writer< 1 %
- Single Selection Widget< 1 %
- Try (Variable Ports)< 1 %
- Vertica Connector< 1 %
- Java Edit Variable (simple)< 1 %
- String Input (legacy)< 1 %
- Integer Widget< 1 %
- DB Delete (Filter)< 1 %
- Value Counter< 1 %
- Breakpoint< 1 %
- Rule Engine Variable< 1 %
CASE Switch Variable (Start)< 1 %- End IF< 1 %
Excel Reader (XLS)< 1 %- Single Selection Configuration< 1 %
- Date&Time Input (legacy)< 1 %
- Integer Input (legacy)< 1 %
- String Widget< 1 %
- Loop End< 1 %
- Column Name Extractor< 1 %
- Create Local Big Data Environment< 1 %
- Counting Loop Start< 1 %
- Capture Workflow Start< 1 %
- DB Row Manipulator< 1 %
Table Row To Variable Loop Start< 1 %- Wait...< 1 %
Table Row to Variable< 1 %- Java Edit Variable< 1 %
Loop End< 1 %- DB Update< 1 %
- Active Branch Inverter< 1 %
- Variable to Table Row< 1 %
- Extract Context Properties< 1 %
- Table View (JavaScript)< 1 %
- Refresh Button Widget< 1 %
- Value Selection Widget< 1 %
- Extract Table Dimension< 1 %
- List Box Configuration< 1 %
- String Manipulation< 1 %
- Math Formula (Variable)< 1 %
- DB Table Remover< 1 %
- Extract Variables (Data)< 1 %
Table Column to Variable< 1 %- Java Snippet< 1 %
Merge Variables< 1 %- DB Delete (Table)< 1 %
- DB Reader< 1 %
- DB Query Reader< 1 %
- DB Query Extractor< 1 %
- TimeDelay Loop Start< 1 %
- Date&Time Configuration< 1 %
- Double Configuration< 1 %
- Integer Configuration< 1 %
- Value Selection Configuration< 1 %
- Date&Time Widget< 1 %
Container Input (Variable)< 1 %- Python Edit Variable (legacy)< 1 %
- Table Writer< 1 %
- Variable Loop End< 1 %
- CASE Switch End< 1 %
- DB Merge< 1 %
- DB Transaction End< 1 %
- Create File/Folder Variables< 1 %
- String to Path (Variable)< 1 %
- Container Input (Variable)< 1 %
- Create Date&Time Range< 1 %
Call Workflow Service< 1 %- Read Variables< 1 %
- Missing Value< 1 %
- Workflow Service Input< 1 %
- DB Table Exists IF Switch< 1 %
- Benchmark Start< 1 %
- Joiner< 1 %
- Column Expressions< 1 %
- Concatenate< 1 %
Database Writer< 1 %Generic Loop Start< 1 %- Column Filter< 1 %
- Number to String< 1 %
- Repository File Chooser Configuration< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Delete Files (legacy)< 1 %
CSV Writer< 1 %CASE Switch Variable (End)< 1 %- Spark to Hive< 1 %
- DB Sorter< 1 %
- Multiple Selection Configuration< 1 %
- Python Source (legacy)< 1 %
Catch Errors (DB Ports)< 1 %- Catch Errors (Var Ports)< 1 %
- Interval Loop Start< 1 %
Table Row To Variable Loop Start< 1 %Column Rename< 1 %- Rule Engine< 1 %
CASE Switch Model (Start)< 1 %- Excel Reader< 1 %
- Modify Time< 1 %
- Catch Errors (Generic Ports)< 1 %
- Inject Variables (Database)< 1 %
Table Column to Variable< 1 %Database Connection Table Reader< 1 %Counting Loop Start< 1 %- Column List Loop Start< 1 %
CASE Switch Model (End)< 1 %SQLite Connector< 1 %Microsoft SQL Server Connector< 1 %DB Loader< 1 %Excel Reader (XLS)< 1 %Excel Writer (XLS)< 1 %- Value Selection (legacy)< 1 %
- Date&Time to String< 1 %
- Database Table Exists IF Switch (Legacy)< 1 %
Database IF Switch< 1 %- Inject Variables (Data)< 1 %
- Reference Column Filter< 1 %
- Boolean Widget< 1 %
Table Row to Variable< 1 %- List to FlowVariable< 1 %
Flow Variable End IF< 1 %- Table Row To Variable Run-to-time Loop Start< 1 %
- Benchmark Start (Flow Variable)< 1 %
Table Column to Variable< 1 %CSV Reader< 1 %Database Reader< 1 %File Reader< 1 %Table Reader< 1 %Variable Loop End< 1 %- Column Auto Type Cast< 1 %
- Category to Number< 1 %
- Double to Integer< 1 %
Row Filter (deprecated)< 1 %- Reference Row Filter< 1 %
- DB Type Mapper< 1 %
- DB Column Filter< 1 %
Excel Sheet Appender (XLS)< 1 %- Column Selection Configuration< 1 %
- Value Filter (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Single Selection (legacy)< 1 %
- Slider Widget< 1 %
Python Script (1⇒1)< 1 %- String to Date&Time< 1 %
- Date&Time Shift< 1 %
- Credential Variable Extractor< 1 %
- Try (Data Ports)< 1 %
- Variable to Table Column< 1 %
- Extract Variables (Database)< 1 %
Database Column Filter< 1 %- CSV Reader< 1 %
- Nominal Value Row Filter< 1 %
Joiner< 1 %- Normalizer< 1 %
- IF Switch< 1 %
- Cache< 1 %
- Create Temp Dir (legacy)< 1 %
- Timer Info< 1 %
- Spark DataFrame Java Snippet (Sink)< 1 %
- Spark SQL Query< 1 %
- Amazon S3 File Picker (legacy)< 1 %
MySQL Connector< 1 %PostgreSQL Connector< 1 %- Parameterized DB Query Reader< 1 %
- Model Loop Start< 1 %
- Math Formula< 1 %
- Path to String (Variable)< 1 %
Google Authenticator (API Key)< 1 %- Credentials Configuration< 1 %
- List Box Input (legacy)< 1 %
- Column Selection Widget< 1 %
- Container Input (Credentials)< 1 %
- Python Script (legacy)< 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 2265 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.