- Type: DB DataDB DataDB Data with the database query to extract.
Node details
Input ports
Output ports
- Type: Flow VariableSQL query flow variableThe database query as a flow variable.
- Type: TableSQL query tableThe database query as a string cell in a table with 1 row and 1 column.
Extension
The DB Query Extractor node is part of this extension:
- Go to item
Related workflows & nodes
- Go to item
Database Operations
This workflow shows how to connect to a database and implement SQL queries, as free text …jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter2 > 1. Database_Operations - Go to item
Database Operations
This workflow shows how to connect to a database and implement SQL queries, as free text …jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.3_20210222 > Chapter2 > 1. Database_Operations - Go to item
Database Operations
This workflow shows how to connect to a database and implement SQL queries, as free text …rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.4_20210803 > AdvancedLuck > Chapter2 > 1. Database_Operations - Go to item
Database Operations
This workflow shows how to connect to a database and implement SQL queries, as free text …rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.5_2022011 > AdvancedLuck > Chapter2 > 1. Database_Operations - Go to item
Database Operations
This workflow shows how to connect to a database and implement SQL queries, as free text …rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.6_20220810 > AdvancedLuck > Chapter2 > 1. Database_Operations - Go to item
Database Operations
This workflow shows how to connect to a database and implement SQL queries, as free text …rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.7_20230123 > AdvancedLuck > Chapter2 > 1. Database_Operations - Go to item
School of duplicates - and how to deal with them - H2 version
Dealing with duplicates is a constant theme with data scientist. And a lot of things can …mlauber71 > Public > kn_example_duplicates_school_of_db_h2
No known nodes available