This node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.
This node allows a user to create a new database table either manually or based on the data table spec of an input data table (see "Use dynamic settings" below). The node supports advanced options such as null or not null, primary key or unique keys, default SQL type mapping based on column name or KNIME data type, and default key definitions based on column names.
Tick the "Use dynamic settings" option to enable the dynamic settings behavior. Once enable it allows to dynamically define the SQL type of the columns as well as the assignment of columns to primary or unique keys. All dynamic settings which are made via the Dynamic Type Settings and Dynamic Column Settings tab are applied to the data table specification of the input data table. The mappings defined in the Name-Based SQL Type Mapping have a higher priority than the mappings defined in the KNIME-Based SQL Type Mapping. If no mapping is defined in both Name-Based SQL Type mapping and KNIME-Based SQL Type Mapping, then the default mapping is used. While in dynamic settings mode the "Columns" and "Keys" tab become read-only to allow you a preview of the dynamic settings.
Options
Settings
Columns
Keys
Additional Options
Dynamic Type Settings
Dynamic Keys Settings
Popular Predecessors
String To Number3 %Database SQL Executor3 %Database GroupBy3 %- String to Date&Time3 %
Joiner2 %- Column Filter2 %
- String Manipulation (Variable)2 %
Excel Reader (XLS)2 %Variable to Table Column2 %Parameterized Database Query2 %Row Filter (deprecated)2 %Excel Writer (XLS)2 %Database Column Filter2 %- Column Resorter2 %
- XPath2 %
Table Reader2 %H2 Connector2 %Excel Reader (XLS)2 %CSV Reader1 %SQL Inject1 %Loop End1 %Variable Loop End1 %PostgreSQL Connector1 %- Modify Time< 1 %
- Upload (legacy)< 1 %
Table Row To Variable Loop Start< 1 %Database Table Creator< 1 %- Column Auto Type Cast< 1 %
- Reference Column Filter< 1 %
- GroupBy< 1 %
- Ungroup< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
Microsoft SQL Server Connector< 1 %- Empty Table Creator< 1 %
Excel Reader (XLS)< 1 %Database Sampling< 1 %- DB Writer< 1 %
- Excel Reader< 1 %
Database Connection Table Reader< 1 %Database Table Connector< 1 %Database Reader< 1 %Database Table Selector< 1 %Database Connector< 1 %- Table Creator< 1 %
- Column Combiner< 1 %
Number To String< 1 %- Table Transposer< 1 %
MySQL Connector< 1 %SQLite Connector< 1 %- Java Snippet (simple)< 1 %
- Column Aggregator< 1 %
- Nominal Value Row Filter< 1 %
- Rank< 1 %
- Row Filter (Labs)< 1 %
Database Row Filter< 1 %Database Sorter< 1 %Table Writer< 1 %- Java Snippet< 1 %
- Concatenate< 1 %
- Column Name Extractor< 1 %
- Create Table Structure< 1 %
- Double to Integer< 1 %
Column Rename< 1 %Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %- Table Validator (Reference)< 1 %
String To Number (PMML)< 1 %- Math Formula (Multi Column)< 1 %
- Table Editor (JavaScript)< 1 %
- File Reader< 1 %
Database Joiner< 1 %File Reader< 1 %- Column Rename (Regex)< 1 %
- Cross Joiner< 1 %
- String Manipulation< 1 %
- Extract Table Spec< 1 %
- String to Date/Time (legacy)< 1 %
- CIR< 1 %
- Number to String< 1 %
- Nominal Value Row Splitter< 1 %
- Low Variance Filter< 1 %
- DB Query Reader< 1 %
Table Row to Variable< 1 %Database Drop Table< 1 %Row Splitter (deprecated)< 1 %- RowID< 1 %
- Sorter< 1 %
- Column Splitter< 1 %
- Value Counter< 1 %
- End IF< 1 %
Hive Loader (legacy)< 1 %Impala Connector< 1 %Python Script (2⇒2)< 1 %Loop End (Upto 4 ports)< 1 %Variable to Table Column< 1 %- Java Edit Variable< 1 %
- Pivot< 1 %
- Number Rounder< 1 %
- Modify Date< 1 %
- Modify Time Zone< 1 %
- Mask Date/Time (legacy)< 1 %
- Twitter Timeline (legacy)< 1 %
- CSV Reader< 1 %
- Table Row to Variable Loop Start< 1 %
- DB Reader< 1 %
- Image to Table< 1 %
Database Query< 1 %Database Update< 1 %SQL Extract< 1 %- Chunk Loop Start< 1 %
Concatenate (Optional in)< 1 %Column Appender< 1 %- Column Renamer (Dictionary)< 1 %
- Constant Value Column< 1 %
- Missing Value< 1 %
ORC Writer< 1 %Hive Connector< 1 %Amazon Redshift Connector< 1 %- Math Formula< 1 %
- Strings to Document< 1 %
- String Input (legacy)< 1 %
Python Source< 1 %- R to Table< 1 %
- POST Request< 1 %
- Date&Time to legacy Date&Time< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Date Field Extractor (legacy)< 1 %
- Twitter Search (legacy)< 1 %
- Database Table Exists IF Switch (Legacy)< 1 %
Database End IF< 1 %- European PubMed Central Advanced Search< 1 %
- Create Collection Column< 1 %
- Copy/Move Files (legacy)< 1 %
- Delete Files (legacy)< 1 %
- Create File Name (legacy)< 1 %
Table Column to Variable< 1 %Database Connection Table Writer< 1 %Database Looping< 1 %Database Pivot< 1 %- Loop End (Column Append)< 1 %
Counting Loop Start< 1 %- Column List Loop Start< 1 %
Generic Loop Start< 1 %- k-Means< 1 %
Cell Replacer< 1 %Cell Splitter< 1 %- Cell Splitter By Position< 1 %
- String to Number< 1 %
- Duplicate Row Filter< 1 %
- Missing Value Column Filter< 1 %
- Reference Column Resorter< 1 %
- One-way ANOVA< 1 %
- Empty Table Switch< 1 %
CASE Switch Data (Start)< 1 %- Cache< 1 %
- Extract Table Dimension< 1 %
- Data Generator< 1 %
- Color Manager< 1 %
Impala Loader (legacy)< 1 %- DB Insert< 1 %
- Counter Generation< 1 %
- Quasirandom Sequence Generator (Apache)< 1 %
- Column Expressions (legacy)< 1 %
- Stop Word Filter< 1 %
RSS Feed Reader< 1 %- Value Filter (legacy)< 1 %
- Boolean Input (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- XML to JSON< 1 %
- JSON to Table< 1 %
- Python Source (legacy)< 1 %
- R Snippet< 1 %
- Date&Time to String< 1 %
Extract Date&Time Fields< 1 %- Feed Parser< 1 %
- Database List Tables (Legacy)< 1 %
- Table Row to Variable< 1 %
- Table Reader< 1 %
- Binner (Dictionary)< 1 %
- Joiner< 1 %
- PostgreSQL Connector< 1 %
- DB Table Creator< 1 %
- Salesforce Simple Query< 1 %
Views
- This node has no views
Workflows
- No workflows found
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.