Executes an entered SQL query and returns the result as KNIME data table.
Options
Settings
Input Type Mapping
This tab allows you to define rules to map from database types to KNIME types.
Popular Successors
- GroupBy9 %
Row Filter (deprecated)7 %- Excel Writer6 %
- Rule-based Row Filter4 %
- Column Filter4 %
- Concatenate3 %
- CSV Writer3 %
- String Manipulation3 %
- DB Writer3 %
- Loop End3 %
- Duplicate Row Filter3 %
- Rule Engine2 %
- Column Expressions2 %
- Reference Row Filter2 %
- DB Insert1 %
- String Manipulation (Multi Column)1 %
- String to Date&Time1 %
- Sorter1 %
- Pivot1 %
- DB Query Reader1 %
- Math Formula1 %
- String to Number1 %
- Date&Time to String< 1 %
- Number to String< 1 %
- Rule-based Row Splitter< 1 %
- Constant Value Column< 1 %
- Table Manipulator< 1 %
- Date&Time Part Extractor< 1 %
- Missing Value< 1 %
- Cross Joiner< 1 %
- DB Connection Closer< 1 %
- Table Writer< 1 %
- Table Row to Variable Loop Start< 1 %
Row Splitter (deprecated)< 1 %Joiner< 1 %- Date&Time-based Row Filter< 1 %
- Parquet Writer< 1 %
- DB Table Creator< 1 %
- Nominal Value Row Filter< 1 %
- Cell Splitter< 1 %
- Empty Table Switch< 1 %
- DB Loader< 1 %
- DB Update< 1 %
- Data to Report (BIRT)< 1 %
- Group Loop Start< 1 %
- Number Rounder< 1 %
- Java Snippet< 1 %
- Column Renamer< 1 %
- Reference Column Filter< 1 %
- DB Delete (Table)< 1 %
- String to JSON< 1 %
- Date&Time Difference< 1 %
- Column Resorter< 1 %
Tableau Writer (Hyper)< 1 %- DB SQL Executor< 1 %
- Parameterized DB Query Reader< 1 %
- Date&Time Shift< 1 %
- Missing Value Column Filter< 1 %
- Variable Loop End< 1 %
- Column Renamer (Dictionary)< 1 %
- CASE Switch End< 1 %
- Google Sheets Writer< 1 %
Extract Date&Time Fields< 1 %- Column Appender< 1 %
- Cache< 1 %
- DB Merge< 1 %
- Catch Errors (Data Ports)< 1 %
Loop End< 1 %Table Row to Variable< 1 %- Column Name Extractor< 1 %
- Scatter Plot (JavaScript)< 1 %
CSV Writer< 1 %- Reference Row Splitter< 1 %
- IF Switch< 1 %
- Chunk Loop Start< 1 %
- Row Filter (Labs)< 1 %
- Table Difference Finder< 1 %
- Table View< 1 %
- DB Looping< 1 %
- Table Row to Variable< 1 %
Cell Replacer< 1 %- Value Lookup< 1 %
- Google Sheets Updater< 1 %
- Table to JSON< 1 %
- Variable to Table Column< 1 %
Table Writer< 1 %- k-Means< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Table Transposer< 1 %
- Unpivot< 1 %
- Value Counter< 1 %
- Add Empty Rows< 1 %
- Column Rename (Regex)< 1 %
- Nominal Value Row Splitter< 1 %
- Column Splitter< 1 %
- Extract Table Spec< 1 %
- Molecule Type Cast< 1 %
- Math Formula (Multi Column)< 1 %
- Moving Aggregator< 1 %
Table to HTML String< 1 %- Try (Data Ports)< 1 %
- Column Combiner< 1 %
- Double to Integer< 1 %
- String Replacer< 1 %
Parquet Writer< 1 %- Microsoft SQL Server Connector< 1 %
Excel Sheet Appender (XLS)< 1 %- JSON Path< 1 %
Table Row to Variable< 1 %Concatenate (Optional in)< 1 %- Column Merger< 1 %
- Table Validator (Reference)< 1 %
Column Rename< 1 %- DB Query Extractor< 1 %
- Value Filter (legacy)< 1 %
- Create Collection Column< 1 %
Loop End (2 ports)< 1 %- Merge Variables< 1 %
- Histogram (legacy)< 1 %
Python Script (2⇒2)< 1 %- Extract Variables (Data)< 1 %
- CSV Reader< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Column Auto Type Cast< 1 %
- Domain Calculator< 1 %
- CASE Switch Start< 1 %
- End IF< 1 %
- Timer Info< 1 %
Excel Reader (XLS)< 1 %- Table View (JavaScript)< 1 %
- Python Predictor (legacy)< 1 %
- Modify Time< 1 %
- Upload (legacy)< 1 %
- Table Column to Variable< 1 %
Counting Loop Start< 1 %- Column List Loop Start< 1 %
- Fuzzy c-Means< 1 %
- Case Converter< 1 %
- Filter Apply< 1 %
- Rank< 1 %
- RowID< 1 %
- String Manipulation (Variable)< 1 %
CASE Switch Data (End)< 1 %- Color Manager< 1 %
- Bar Chart< 1 %
- Pie Chart< 1 %
- Statistics View< 1 %
DB Loader< 1 %- DB Table Remover< 1 %
Excel Reader (XLS)< 1 %- Tableau Writer< 1 %
Tableau Writer (TDE)< 1 %- Date&Time Configuration< 1 %
- Line Plot (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
Flow Variable End IF< 1 %- Wait...< 1 %
- Catch Errors (Var Ports)< 1 %
- String to Number (PMML)< 1 %
- Extract Table Dimension< 1 %
- Interactive Pie chart (legacy)< 1 %
- Save Workflow< 1 %
- Parallel Chunk Start< 1 %
- PostgreSQL Connector< 1 %
- DB Transaction End< 1 %
- Variable Expressions< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Java Snippet Row Filter< 1 %
- Tag Cloud (JavaScript)< 1 %
- R Snippet< 1 %
- Benchmark End< 1 %
- Binary Objects to Strings< 1 %
- Breakpoint< 1 %
- Inject Variables (Data)< 1 %
- Counting Loop Start< 1 %
- Naive Bayes Predictor< 1 %
- Cell Splitter By Position< 1 %
- Column Comparator< 1 %
- Column Aggregator< 1 %
- One to Many< 1 %
- Equal Size Sampling< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply Row Splitter< 1 %
- Joiner< 1 %
- Number to String (PMML)< 1 %
- Top k Row Filter< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Numeric Outliers< 1 %
- Statistics< 1 %
- Line Plot (legacy)< 1 %
- Heatmap< 1 %
- Line Plot< 1 %
- Amazon Authenticator< 1 %
- Parallel Chunk End< 1 %
- DB Reader< 1 %
- Random Number Assigner< 1 %
- Autocomplete Text Widget< 1 %
Microsoft Authenticator (Deprecated)< 1 %Excel Writer (XLS)< 1 %- Excel Reader< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
Python Script (1⇒1)< 1 %- Python Script (legacy)< 1 %
- Python View (legacy)< 1 %
- Table to R< 1 %
- GET Request< 1 %
- POST Request< 1 %
- Table Difference Checker< 1 %
- Date&Time to legacy Date&Time< 1 %
- Legacy Date&Time to Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Modify Time Zone< 1 %
- Table to HTML String< 1 %
Regex Extractor< 1 %- XLS Control Table Generator< 1 %
- Binary Objects to Files< 1 %
Table Row To Variable Loop Start< 1 %- Variable to Table Row< 1 %
- Table to Image< 1 %
Database Writer< 1 %Database Looping< 1 %Parameterized Database Query< 1 %- Table Creator< 1 %
- Variable Creator< 1 %
- Loop End (Column Append)< 1 %
- Interval Loop Start< 1 %
- Generic Loop Start< 1 %
- Recursive Loop End< 1 %
- Recursive Loop Start< 1 %
- PNN Learner (DDA)< 1 %
- Linear Regression Learner< 1 %
- Regression Predictor< 1 %
- Scorer< 1 %
- Association Rule Learner< 1 %
- Random Forest Predictor< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Bootstrap Sampling< 1 %
- Category to Number< 1 %
- Lag Column< 1 %
- Linear Correlation< 1 %
- Table Validator< 1 %
- Row Splitter (Labs)< 1 %
- Normalizer< 1 %
- Partitioning< 1 %
- String Splitter (Regex)< 1 %
- Row Aggregator< 1 %
- Row Sampling< 1 %
- Table Splitter< 1 %
- Ungroup< 1 %
- Data Explorer< 1 %
CASE Switch Data (Start)< 1 %- Send Email< 1 %
- Crosstab< 1 %
- Interactive Table (legacy)< 1 %
- ORC Writer< 1 %
Parquet Writer< 1 %- Capture Workflow End< 1 %
- DB Connector< 1 %
- DB Row Manipulator< 1 %
- DB Row Filter< 1 %
- DB Query Injector< 1 %
DB Table Creator< 1 %- DB Table Selector< 1 %
- Counter Generation< 1 %
- TimeDelay Loop End< 1 %
- String Distances< 1 %
- Similarity Search< 1 %
- Table to PMML Ensemble< 1 %
- Table to HTML (legacy)< 1 %
- Table to PDF (legacy)< 1 %
- OpenBabel< 1 %
- Table to H2O< 1 %
- OSM Map View< 1 %
- Excel Cell Updater< 1 %
- Send to Power BI< 1 %
- SharePoint Online List Writer< 1 %
- SMB Connector< 1 %
- Java Snippet (simple)< 1 %
- Send to Tableau Server< 1 %
- String Matcher< 1 %
- Strings to Document< 1 %
- Create File/Folder Variables< 1 %
- String to Path< 1 %
- String to Path (Variable)< 1 %
- Google Sheets Appender< 1 %
- Column Filter Configuration< 1 %
- String Configuration< 1 %
- Value Selection Configuration< 1 %
- Value Selection (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Date&Time Widget< 1 %
- Value Selection Widget< 1 %
- Container Output (Table)< 1 %
- JSON Transformer< 1 %
- Columns to JSON< 1 %
- JSON to Table< 1 %
- Python Learner (legacy)< 1 %
- Add Table to R< 1 %
- Create Date&Time Range< 1 %
- Modify Date< 1 %
- Date Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- String to XML< 1 %
- R Snippet (2:1)< 1 %
- ARIMA Predictor< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %Image Writer (Table Column)< 1 %Database SQL Executor< 1 %Recursive Loop End< 1 %Recursive Loop Start< 1 %- Numeric Row Splitter< 1 %
- k-Medoids< 1 %
- Violin Plot (Plotly)< 1 %
Table to PDF< 1 %- Date&Time Input (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
JSON Writer< 1 %- Reaction Splitter< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Binary Objects to PNGs< 1 %
Variable to Table Row< 1 %Database Table Creator< 1 %- Model Reader< 1 %
- Variable Condition Loop End< 1 %
Variable Condition Loop End< 1 %- MultiLayerPerceptron Predictor< 1 %
- Random Forest Learner< 1 %
- Binner (Dictionary)< 1 %
Linear Correlation< 1 %- Low Variance Filter< 1 %
- Normalizer (PMML)< 1 %
- Single sample t-test< 1 %
- Shape Manager< 1 %
- Gaussian Distributed Assigner< 1 %
- Line Plot (Plotly)< 1 %
- Scatter Plot (Plotly)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Index Query< 1 %
- Table Indexer< 1 %
Send to Power BI< 1 %- Transfer Files (Table)< 1 %
- Nominal Row Filter Configuration< 1 %
- Column Selection Configuration< 1 %
- Container Input (Row)< 1 %
- Object Inserter< 1 %
- Python Source (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- XML Column Combiner< 1 %
XML Writer< 1 %- Network Component Splitter< 1 %
- Polygon Properties< 1 %
- ARIMA Visualization< 1 %
- Copy/Move Files (legacy)< 1 %
- Active Branch Inverter< 1 %
Table Column to Variable< 1 %- Java Edit Variable< 1 %
Interval Loop Start< 1 %Table Row To Variable Loop Start< 1 %Variable Loop End< 1 %- Fuzzy Rule Learner< 1 %
- Cluster Assigner< 1 %
- Hierarchical Cluster View< 1 %
- Decision Tree to Image< 1 %
- Decision Tree Learner< 1 %
- Polynomial Regression Learner< 1 %
String To Number< 1 %- Reference Column Splitter< 1 %
- Interactive HiLite Collector< 1 %
Rank Correlation< 1 %- Rank Correlation< 1 %
CASE Switch Variable (End)< 1 %CASE Switch Variable (Start)< 1 %Merge Variables< 1 %- Conditional Box Plot (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- DB Column Filter< 1 %
- DB Query< 1 %
- DB Transaction Start< 1 %
- External Tool< 1 %
XLS Writer< 1 %- Java Snippet Row Splitter< 1 %
Send to Tableau Server (Hyper)< 1 %- List Files/Folders< 1 %
- Column Filter (legacy)< 1 %
Column Filter Widget< 1 %- Text Output Widget (legacy)< 1 %
- Container Output (JSON)< 1 %
- MongoDB Writer< 1 %
Python Script (2⇒1)< 1 %- Window Loop Start< 1 %
- XGBoost Predictor (Regression)< 1 %
- Column to XML< 1 %
- Text Classifier Predictor< 1 %
- Latitude/Longitude to Coordinate< 1 %
- HTTP Retriever< 1 %
- CIR< 1 %
- Reaction Automapper< 1 %
- TIBCO Spotfire File Writer< 1 %
- Database To Variable (Legacy)< 1 %
IF Switch (Flow Variable Value)< 1 %- Multiport Loop End< 1 %
- Benchmark End (Flow Variable)< 1 %
- Insert into List< 1 %
- URL Encode< 1 %
- Vector Length Normalization< 1 %
- Matlab Snippet< 1 %
Python Snippet< 1 %- R Snippet< 1 %
- Open in R< 1 %
- Advanced MolConverter< 1 %
- MarvinView< 1 %
- MolConverter< 1 %
- Extract URI Info< 1 %
- String to URI< 1 %
- URL to File Path (Variable)< 1 %
- Try (Variable Ports)< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %Variable to Table Row< 1 %CSV Reader< 1 %Database Update< 1 %Database Table Selector< 1 %Database Connector< 1 %Extract Context Properties< 1 %File Reader< 1 %List Files< 1 %Model Reader< 1 %Table Reader< 1 %- Feature Selection Filter< 1 %
Generic Loop Start< 1 %Recursive Loop End (2 ports)< 1 %Recursive Loop Start (2 ports)< 1 %- X-Partitioner< 1 %
- Naive Bayes Learner< 1 %
- Hierarchical Clustering< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
- Decision Tree Predictor< 1 %
- K Nearest Neighbor< 1 %
- MDS (DistMatrix)< 1 %
- RProp MLP Learner< 1 %
- Logistic Regression Learner< 1 %
- Logistic Regression Predictor< 1 %
- SVM Learner< 1 %
- PCA Apply< 1 %
- PCA< 1 %
Gradient Boosted Trees Predictor< 1 %- Random Forest Predictor (Regression)< 1 %
Cell Splitter< 1 %- Category to Number (Apply)< 1 %
- Number to Category (Apply)< 1 %
Number To String< 1 %Column Appender< 1 %- Many to One< 1 %
- CAIM Binner< 1 %
- HiLite Row Splitter< 1 %
- Subset Matcher< 1 %
- Normalizer (Apply)< 1 %
- Numeric Binner (PMML)< 1 %
- Missing Value (Apply)< 1 %
- Set Operator< 1 %
String Replace (Dictionary)< 1 %- Ruleset Editor< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
Linear Discriminant Analysis< 1 %- Lift Chart (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
ORC Writer< 1 %- HDFS File Permission (legacy)< 1 %
Hive Loader (legacy)< 1 %- Table to Spark< 1 %
- Capture Workflow Start< 1 %
- SDF Extractor< 1 %
- SDF Writer< 1 %
- Amazon DynamoDB Put Item< 1 %
- Amazon Redshift Connector< 1 %
- Oracle Connector< 1 %
- Random Label Assigner (Data)< 1 %
- Time Series Generator< 1 %
- Numeric Distances< 1 %
- K Nearest Neighbor (Distance Function)< 1 %
- PMML Predictor< 1 %
- Generic Web Service Client< 1 %
- HeatMap (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
Excel Reader (XLS)< 1 %- Java Edit Variable (simple)< 1 %
- Java IF (Table)< 1 %
- Spark Line Appender< 1 %
Send to Tableau Server (TDE)< 1 %- Chi-Square Keyword Extractor< 1 %
- Markup Tag Filter< 1 %
- Stop Word Filter< 1 %
- Unique Term Extractor< 1 %
- t-SNE (L. Jonsson)< 1 %
- Path to String (Variable)< 1 %
- Touches< 1 %
- GeoJSON writer< 1 %
- JPMML Regression Predictor< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- Value Filter Definition (legacy)< 1 %
- String Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Decision Tree View (JavaScript)< 1 %
- Lift Chart (JavaScript)< 1 %
- List Box Widget< 1 %
- Column Selection Widget< 1 %
- JSON Row Combiner and Writer< 1 %
- Container Input (Table)< 1 %
- JSON Writer< 1 %
- XML to JSON< 1 %
- JSON to XML< 1 %
MongoDB Writer< 1 %- Feature Inserter< 1 %
- Multi Feature Inserter< 1 %
Python Script (1⇒2)< 1 %- Python Edit Variable (legacy)< 1 %
- R View (Table)< 1 %
- PUT Request< 1 %
- Duration to Number< 1 %
- Extract Duration Fields< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Difference (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Moving Average< 1 %
- Preset Date/Time (legacy)< 1 %
- XGBoost Predictor< 1 %
- XML Row Combiner< 1 %
- XPath< 1 %
- Molecule to CDK< 1 %
- Fingerprints< 1 %
- RDKit From Molecule< 1 %
- RDKit To Molecule< 1 %
Location Extractor< 1 %- WebDriver Factory< 1 %
Views
- This node has no views
Workflows
[01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub
00_xplan sf dbconv-insert via xport-AccountKNIME Hub- 0009582-6KNIME Hub
- 01_Database_Simple_IO_ExampleKNIME Hub
- 01_Database_Simple_IO_ExampleKNIME Hub
- Show all 465 workflows
Links
- DB Table Selector does not display all tablesby mlauber71 on 2019-10-18forum.knime.com/p/72723
- Accessing huge Microsoft Access DBby izaychik63 on 2020-03-05forum.knime.com/p/83492
- Failure in Executing Oracle Procedure from DB Query Readerby AnotherFraudUser on 2021-05-02forum.knime.com/p/122486
- Extract Date from postgresql databaseby izaychik63 on 2022-12-12forum.knime.com/p/182982
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.