Executes the input query in the database and retrieves the result into a KNIME data table.
If the node consumes a lot of memory you might want to decrease the "Fetch size" in the "Advanced" tab
of the corresponding connector node. The fetch size specifies how many rows are fetched from the
database server into KNIME per network round trip. The higher the number the more memory is consumed.
However the smaller the number the more network round trips are necessary to fetch large results.
Also not all JDBC driver support this option and thus might ignore it.
Popular Successors
- Joiner15 %
Row Filter (deprecated)9 %- GroupBy8 %
- Excel Writer7 %
- Column Filter4 %
- Rule-based Row Filter3 %
- Concatenate3 %
- Math Formula2 %
- String Manipulation2 %
- DB Writer2 %
- Rule Engine2 %
- CSV Writer2 %
- Sorter2 %
- Duplicate Row Filter2 %
- Pivot1 %
Joiner1 %- Reference Row Filter1 %
- Loop End< 1 %
- String to Number< 1 %
- Column Resorter< 1 %
- Column Expressions (legacy)< 1 %
- Rule-based Row Splitter< 1 %
- Value Lookup< 1 %
- DB Insert< 1 %
- String to Date&Time< 1 %
- DB Table Creator< 1 %
- Date&Time-based Row Filter< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Missing Value< 1 %
- Date&Time Part Extractor< 1 %
- DB Connection Closer< 1 %
- Number to String< 1 %
- Constant Value Column< 1 %
- Reference Row Splitter< 1 %
- Double to Integer< 1 %
- Table View (JavaScript)< 1 %
- Table Writer< 1 %
- String Manipulation (Multi Column)< 1 %
- Numeric Outliers< 1 %
- Unpivot< 1 %
- Math Formula (Multi Column)< 1 %
- Cross Joiner< 1 %
- Date&Time to String< 1 %
- Date&Time Difference< 1 %
- Cell Splitter< 1 %
- Column Renamer< 1 %
- Rank< 1 %
Cell Replacer< 1 %- Chunk Loop Start< 1 %
- Empty Table Switch< 1 %
- Table Manipulator< 1 %
- Date&Time Shift< 1 %
- Column Name Extractor< 1 %
- Row Filter (Labs)< 1 %
- DB Loader< 1 %
- Top k Row Filter< 1 %
- Parameterized DB Query Reader< 1 %
Send to Tableau Server (Hyper)< 1 %- DB Update< 1 %
Tableau Writer (Hyper)< 1 %- DB Delete (Table)< 1 %
- DB Merge< 1 %
- Value Filter (legacy)< 1 %
- Table Transposer< 1 %
- Parquet Writer< 1 %
- Value Selection Configuration< 1 %
- DB Query Reader< 1 %
- Table Row to Variable Loop Start< 1 %
- Group Loop Start< 1 %
- Column Combiner< 1 %
- Column Appender< 1 %
- Column Rename (Regex)< 1 %
- Modify Date< 1 %
- Table Reader< 1 %
- Row Sampling< 1 %
- Pie Chart< 1 %
Python Script (2⇒1)< 1 %- Table Difference Finder< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to Date/Time (legacy)< 1 %
- Recursive Loop Start< 1 %
- Decision Tree Predictor< 1 %
- DB Looping< 1 %
- Container Output (Table)< 1 %
- Modify Time< 1 %
- ARFF Writer< 1 %
- Column Aggregator< 1 %
- Column Renamer (Dictionary)< 1 %
- Statistics< 1 %
- DB Row Manipulator< 1 %
- DB Query< 1 %
- Send to Power BI< 1 %
- Try (Variable Ports)< 1 %
Table Row to Variable< 1 %Database Writer< 1 %Table Writer< 1 %- k-Means< 1 %
- Category to Number< 1 %
- Column Merger< 1 %
- Number Rounder< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer< 1 %
- Extract Table Spec< 1 %
- Interactive Pie chart (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Speedy Sequence Alignment Visualisation< 1 %
- Binary Objects to Files< 1 %
- Java Snippet< 1 %
- PCA< 1 %
- Add Empty Rows< 1 %
- Number to Category (Apply)< 1 %
- Nominal Value Row Splitter< 1 %
- Number to String (PMML)< 1 %
- String Splitter (Regex)< 1 %
Column Rename< 1 %- RowID< 1 %
- Timer Info< 1 %
- Table View< 1 %
- Line Plot (Plotly)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Excel Cell Updater< 1 %
- Google Sheets Updater< 1 %
- Container Output (JSON)< 1 %
- Write To Excel Template (deprecated)< 1 %
CSV Writer< 1 %- Table Creator< 1 %
Variable Condition Loop End< 1 %Scorer< 1 %- Simple Regression Tree Learner< 1 %
- Case Converter< 1 %
- Domain Calculator< 1 %
- Missing Value Column Filter< 1 %
- Ungroup< 1 %
- Data Explorer< 1 %
- Scatter Plot (legacy)< 1 %
- Molecule Type Cast< 1 %
- Variable Expressions (legacy)< 1 %
- SMB Connector< 1 %
- Path to String< 1 %
- Date&Time Configuration< 1 %
- Moving Aggregator< 1 %
- TIBCO Spotfire File Writer< 1 %
- Create Collection Column< 1 %
Variable to Table Column< 1 %- One to Many< 1 %
- Linear Correlation< 1 %
- Reference Column Filter< 1 %
- Column Splitter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- IF Switch< 1 %
- Cache< 1 %
- Merge Variables< 1 %
Merge Variables< 1 %- Bar Chart< 1 %
- DB Reader< 1 %
- DB Concatenate< 1 %
- Table to HTML (legacy)< 1 %
- Table to H2O< 1 %
- Case Converter< 1 %
- Google Sheets Writer< 1 %
- Value Selection (legacy)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- String to JSON< 1 %
- Create Date&Time Range< 1 %
- Workflow Service Output< 1 %
- Anonymization< 1 %
Regex Extractor< 1 %- Standardizer< 1 %
- 2D/3D Scatterplot< 1 %
- Split Collection Column< 1 %
- Try (Data Ports)< 1 %
- Extract Variables (Database)< 1 %
- Table Row to Variable< 1 %
Database Looping< 1 %Database Table Selector< 1 %- Loop End (Column Append)< 1 %
- Column List Loop Start< 1 %
- Variable Loop End< 1 %
- X-Partitioner< 1 %
- Naive Bayes Predictor< 1 %
- Association Rule Learner< 1 %
- Cell Splitter By Position< 1 %
- Column Auto Type Cast< 1 %
- Table Validator< 1 %
- Reference Column Splitter< 1 %
- Row Splitter (Labs)< 1 %
- Reference Column Resorter< 1 %
- String Replacer (Dictionary)< 1 %
- Rule Engine (Dictionary)< 1 %
- Extract Table Dimension< 1 %
- Color Manager< 1 %
- Scatter Plot< 1 %
- Microsoft SQL Server Connector< 1 %
DB Loader< 1 %- DB Row Filter< 1 %
- Similarity Search< 1 %
- Scatter Plot (Plotly)< 1 %
- Table to PDF (legacy)< 1 %
- Index Query< 1 %
- Dictionary Tagger< 1 %
- Column Filter Configuration< 1 %
- Column Selection Configuration< 1 %
- Interactive Value Filter Widget< 1 %
- JSON Path< 1 %
- R Snippet< 1 %
- Date/Time Shift (legacy)< 1 %
- XML Writer< 1 %
- XML Row Combiner< 1 %
- String to XML< 1 %
- Table to HTML String< 1 %
- Total Count< 1 %
- Python Plot< 1 %
- Advanced MolConverter< 1 %
- Binary Objects to PNGs< 1 %
- Binary Objects to Strings< 1 %
- Breakpoint< 1 %
- Wait...< 1 %
- Catch Errors (Data Ports)< 1 %
- Variable to Table Column< 1 %
- Extract Variables (Data)< 1 %
- Inject Variables (Data)< 1 %
- Table Column to Variable< 1 %
- Table to Image< 1 %
Database Reader< 1 %- Image Writer (Table)< 1 %
Loop End< 1 %Generic Loop Start< 1 %- Decision Tree Learner< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Linear Regression Learner< 1 %
- Polynomial Regression Learner< 1 %
- Regression Predictor< 1 %
- Scorer< 1 %
- Random Forest Learner< 1 %
- Random Forest Learner (Regression)< 1 %
- Random Forest Predictor< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Column Comparator< 1 %
- Lag Column< 1 %
- Correlation Filter< 1 %
- Table Validator (Reference)< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- HiLite Row Splitter< 1 %
- Normalizer< 1 %
- Partitioning< 1 %
- Row Aggregator< 1 %
- Numeric Row Splitter< 1 %
- Set Operator< 1 %
- Table Splitter< 1 %
- Table Updater< 1 %
- Value Counter< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- Rank Correlation< 1 %
- One-way ANOVA< 1 %
- CASE Switch End< 1 %
- CASE Switch Start< 1 %
- End IF< 1 %
- Global Timer Info< 1 %
- Conditional Box Plot (legacy)< 1 %
- Crosstab< 1 %
- Histogram (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Box Plot< 1 %
- Line Plot< 1 %
- Statistics View< 1 %
- ORC Writer< 1 %
Parquet Writer< 1 %- Table to Spark< 1 %
- DB Connector< 1 %
- DB Connection Table Writer< 1 %
- DB Connection Extractor< 1 %
- DB SQL Executor< 1 %
- DB Joiner< 1 %
DB Table Creator< 1 %- DB Table Selector< 1 %
- Counter Generation< 1 %
- Autocomplete Text Widget< 1 %
- Violin Plot (Plotly)< 1 %
Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %Send to Power BI< 1 %- Java Snippet (simple)< 1 %
- Send to Tableau Server< 1 %
- Tableau Writer< 1 %
- Keygraph Keyword Extractor< 1 %
- RegEx Filter< 1 %
- Stop Word Filter< 1 %
- Strings to Document< 1 %
- String to Path< 1 %
- Google Sheets Appender< 1 %
- Nominal Row Filter Configuration< 1 %
- Column Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Lift Chart (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Value Selection Widget< 1 %
- Table to JSON< 1 %
- Columns to JSON< 1 %
- JSON to Table< 1 %
- Object Inserter< 1 %
Python Script (1⇒1)< 1 %- Python Script (legacy)< 1 %
- Python View (legacy)< 1 %
- R View (Table)< 1 %
- GET Request< 1 %
- POST Request< 1 %
- Table Difference Checker< 1 %
- Create FileStore Column< 1 %
- Date&Time to legacy Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Modify Time Zone< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Moving Average< 1 %
- Date Extractor< 1 %
- Benchmark Start< 1 %
- Catch Errors (Var Ports)< 1 %
Counting Loop Start< 1 %- SMOTE< 1 %
- Perl Scripting< 1 %
Table to HTML< 1 %Send to Tableau Server (TDE)< 1 %- String Matcher< 1 %
- Dictionary Replacer< 1 %
- Files/Folders Meta Info< 1 %
- Webpage Retriever< 1 %
- RDKit Substructure Filter< 1 %
- Text Classifier Predictor< 1 %
- Start WebDriver< 1 %
- URL Encode< 1 %
- ARIMA Learner< 1 %
- Active Branch Inverter< 1 %
Database Update< 1 %- Counting Loop Start< 1 %
- Cluster Assigner< 1 %
- Fuzzy c-Means< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
- K Nearest Neighbor< 1 %
- Bootstrap Sampling< 1 %
Linear Correlation< 1 %- Edit Nominal Domain< 1 %
- Single sample t-test< 1 %
CASE Switch Data (Start)< 1 %- Hive Connector< 1 %
- Parallel Chunk Start< 1 %
- DB GroupBy< 1 %
- DB Transaction Start< 1 %
- DB Table Remover< 1 %
- Gaussian Distributed Assigner< 1 %
- One Row to Many< 1 %
- String Distances< 1 %
- PMML Predictor< 1 %
- H2O MOJO Predictor (Classification)< 1 %
- Bar Chart (JFreeChart)< 1 %
- Java Snippet Row Splitter< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- Binned Performance< 1 %
- Matlab Snippet< 1 %
- R Snippet (2:1)< 1 %
- MarvinView< 1 %
- MolConverter< 1 %
Binary Objects to Files< 1 %Variable to Table Column< 1 %Variable to Table Row< 1 %Database Table Creator< 1 %Recursive Loop Start (2 ports)< 1 %Recursive Loop Start< 1 %- Fuzzy Rule Learner< 1 %
- Hierarchical Clustering< 1 %
- Decision Tree to Image< 1 %
- Logistic Regression Learner< 1 %
- PCA Compute< 1 %
- Random Forest Predictor (Regression)< 1 %
Concatenate (Optional in)< 1 %- Many to One< 1 %
- Ruleset Editor< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
Rank Correlation< 1 %- Line Plot (legacy)< 1 %
- Size Manager< 1 %
ORC Writer< 1 %Hive Loader (legacy)< 1 %- SQLite Connector< 1 %
- Bar Chart (JavaScript)< 1 %
- Surface Plot (Plotly)< 1 %
- Table to PMML Ensemble< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
- Table Indexer< 1 %
- Geo-Coordinate Row Filter< 1 %
Excel Sheet Appender (XLS)< 1 %- Java IF (Table)< 1 %
Google Authenticator (API Key)< 1 %MongoDB Writer< 1 %- MongoDB Save< 1 %
- Python Learner (legacy)< 1 %
Python Script (2⇒2)< 1 %- Add Table to R< 1 %
- Column to XML< 1 %
- HTTP Retriever< 1 %
- CIR< 1 %
- XLS Control Table Generator< 1 %
- Canonical SMILES< 1 %
- Customer Distributions< 1 %
- Multiport Loop End< 1 %
- Timed Loop End (3 port)< 1 %
- Benchmark End< 1 %
- Inject Column Properties< 1 %
Python Snippet< 1 %- Convert to R< 1 %
- R Plot< 1 %
- Labeling View< 1 %
- Copy/Move Files (legacy)< 1 %
- String to URI< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Image Writer (Table Column)< 1 %- Read Images< 1 %
SQL Extract< 1 %Database Connector< 1 %- Feature Selection Loop Start (1:1)< 1 %
Loop End (2 ports)< 1 %Interval Loop Start< 1 %Recursive Loop End< 1 %Table Row To Variable Loop Start< 1 %- Naive Bayes Learner< 1 %
- DBSCAN< 1 %
- RProp MLP Learner< 1 %
- Logistic Regression Predictor< 1 %
- SVM Learner< 1 %
- SVM Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Distance Matrix Pair Extractor< 1 %
- Binner (Dictionary)< 1 %
Number To String< 1 %String To Number< 1 %Column Appender< 1 %- CAIM Binner< 1 %
- Extract Missing Value Cause< 1 %
- Numeric Binner (PMML)< 1 %
- Column Filter (PMML)< 1 %
- Missing Value (Apply)< 1 %
- Normalizer Apply (PMML)< 1 %
- Normalizer (PMML)< 1 %
- String to Number (PMML)< 1 %
- Shuffle< 1 %
String Replace (Dictionary)< 1 %- Independent groups t-test< 1 %
- Linear Discriminant Analysis Compute< 1 %
- Linear Discriminant Analysis< 1 %
CASE Switch Data (End)< 1 %- Create Temp Dir (legacy)< 1 %
- Send Email< 1 %
- Lift Chart (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
Color Appender< 1 %Parquet Writer< 1 %- SDF Stripper< 1 %
- Amazon Comprehend (Sentiment)< 1 %
- Amazon S3 Connection (legacy)< 1 %
- MySQL Connector< 1 %
- Oracle Connector< 1 %
- Vertica Connector< 1 %
- DB Type Mapper< 1 %
- DB Column Filter< 1 %
- Random Boolean Assigner< 1 %
- Numeric Distances< 1 %
- k-Medoids< 1 %
- Error Bars Plot (Plotly)< 1 %
- Boosting Learner Loop Start< 1 %
- Cell to PMML< 1 %
Table to PDF< 1 %- OpenBabel< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Rule Viewer (local) (Legacy)< 1 %
- OSM Map View< 1 %
XLS Sheet Appender< 1 %XLS Writer< 1 %TIBCO File Writer< 1 %Open TIBCO Spotfire< 1 %- Java Edit Variable (simple)< 1 %
Tableau Writer (TDE)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Tika Language Detector< 1 %
- Tika Parser URL Input< 1 %
- Punctuation Erasure< 1 %
- POS Tagger< 1 %
- StanfordNLP NE Learner< 1 %
- Bag Of Words Creator< 1 %
- t-SNE (L. Jonsson)< 1 %
- JPMML Classifier< 1 %
- List Box Configuration< 1 %
- Value Filter Definition (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Refresh Button Widget< 1 %
- Column Selection Widget< 1 %
- JSON Column Combiner< 1 %
- Container Input (Table)< 1 %
- JSON Writer< 1 %
- XML to JSON< 1 %
- JSON Transformer< 1 %
- Quantile Filter< 1 %
- Data Row to Image< 1 %
- Python Edit Variable (legacy)< 1 %
- R Learner< 1 %
- Table to R< 1 %
- PUT Request< 1 %
- String to Duration< 1 %
- Extract Duration Fields< 1 %
- Date Field Extractor (legacy)< 1 %
- Time to String (legacy)< 1 %
- Country Extractor< 1 %
- Workflow Service Input< 1 %
- XGBoost Predictor< 1 %
- XML Row Combine and Write< 1 %
- XPath< 1 %
- Fingerprints< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit From InChI< 1 %
- RDKit From Molecule< 1 %
- RDKit Fingerprint< 1 %
- Anonymity Assessment< 1 %
- Web Page Content Extractor< 1 %
- Google Address Geocoder< 1 %
- HTML Parser< 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 1913 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.