This node allows a user to create a new database table either manually or based on the specification of a KNIME input data table (see "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.
To change the input or output ports from a DB Connection to a DB Data port, click on ... in the bottom left corner of the node icon. In the menu go to Exchange ports and select the port to change.
Tick the "Use dynamic settings..." option to enable the dynamic settings behaviour. Once enabled 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 Keys 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, then the default mapping is used.
While in dynamic settings mode the "Columns" and "Keys" tabs become read-only to allow you a preview
of the dynamic settings.
Options
Settings
Columns
While in dynamic settings mode the "Columns" tab becomes read-only to allow you a preview of the dynamic settings.
Keys
While in dynamic settings mode the "Keys" tab becomes read-only to allow you a preview of the dynamic settings.
Additional Options
Dynamic Type Settings
Dynamic Keys Settings
Popular Predecessors
- Column Filter6 %
- Excel Reader5 %
Column Rename5 %- Concatenate4 %
- DB Table Remover4 %
- GroupBy3 %
- Joiner3 %
- CSV Reader3 %
Row Filter (deprecated)3 %- String to Date&Time3 %
- Column Resorter3 %
- DB Reader2 %
- Table Creator2 %
- Microsoft SQL Server Connector2 %
- Snowflake Connector2 %
- DB SQL Executor2 %
- Duplicate Row Filter2 %
- SQLite Connector2 %
- Rule-based Row Filter2 %
- DB Query Reader2 %
- DB Connector2 %
- Rule Engine1 %
- Constant Value Column1 %
- String to Number1 %
- Column Expressions1 %
- DB Insert1 %
- MySQL Connector< 1 %
- Missing Value< 1 %
- String Manipulation< 1 %
- PostgreSQL Connector< 1 %
- Cross Joiner< 1 %
- Math Formula< 1 %
- Loop End< 1 %
- DB Connection Extractor< 1 %
- DB Table Creator< 1 %
- Google BigQuery Connector< 1 %
- Oracle Connector< 1 %
- Sorter< 1 %
- Microsoft Access Connector< 1 %
- Column Renamer< 1 %
- Hive Connector< 1 %
- H2 Connector< 1 %
- Table Reader< 1 %
- Chunk Loop Start< 1 %
- Table Manipulator< 1 %
- DB Query< 1 %
- Column Splitter< 1 %
- File Reader< 1 %
- Column Auto Type Cast< 1 %
- Number to String< 1 %
- Partitioning< 1 %
- DB Column Filter< 1 %
- Variable to Table Column< 1 %
- Double to Integer< 1 %
- String Manipulation (Multi Column)< 1 %
- DB Loader< 1 %
- DB Sorter< 1 %
- Credentials Configuration< 1 %
- Collection to String< 1 %
Loop End< 1 %- Cell Splitter< 1 %
- Create Databricks Environment< 1 %
- Empty Table Creator< 1 %
- Excel Writer< 1 %
- Pivot< 1 %
- Reference Row Filter< 1 %
- Fingerprint to Binary String< 1 %
- Table Row to Variable< 1 %
- Column Renamer (Dictionary)< 1 %
- Extract Table Spec< 1 %
- Create Local Big Data Environment< 1 %
- Math Formula (Multi Column)< 1 %
- Create Date&Time Range< 1 %
- DB Merge< 1 %
- Wait...< 1 %
- Table Validator< 1 %
- Variable Condition Loop End< 1 %
- Column Rename (Regex)< 1 %
- Number Rounder< 1 %
- Row Sampling< 1 %
- String Replacer< 1 %
- Merge Variables< 1 %
Parquet Reader< 1 %- DB Connection Table Writer< 1 %
- DB Writer< 1 %
- DB Transaction Start< 1 %
- Date&Time Shift< 1 %
- String Configuration< 1 %
- DB Column Rename< 1 %
- Table Editor (JavaScript)< 1 %
- Amazon Athena Connector< 1 %
- GET Request< 1 %
- DB Concatenate< 1 %
- Multiport Loop End< 1 %
- Table Column to Variable< 1 %
- File Reader (Complex Format)< 1 %
- Variable Creator< 1 %
- Java Snippet< 1 %
- Table Row to Variable Loop Start< 1 %
- Column Combiner< 1 %
- Column Aggregator< 1 %
- Column Appender< 1 %
- Column Name Extractor< 1 %
Row Splitter (deprecated)< 1 %- RowID< 1 %
- String Manipulation (Variable)< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- IF Switch< 1 %
- Data Generator< 1 %
- Impala Connector< 1 %
- SDF Reader< 1 %
- Amazon Redshift Connector< 1 %
- DB Query Extractor< 1 %
- DB Table Selector< 1 %
- Google Sheets Reader< 1 %
- JSON to Table< 1 %
- Python Script (legacy)< 1 %
- Salesforce Simple Query< 1 %
- Date&Time Difference< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date&Time Part Extractor< 1 %
- Date&Time-based Row Filter< 1 %
- Modify Date< 1 %
- Modify Time< 1 %
- Java Snippet (simple)< 1 %
- Parquet Reader< 1 %
- CASE Switch End< 1 %
- Numeric Binner< 1 %
- Modify Time Zone< 1 %
- Row Filter (Labs)< 1 %
- Rule-based Row Splitter< 1 %
- Columns to JSON< 1 %
- DB Joiner< 1 %
- CASE Switch Start< 1 %
- Active Branch Inverter< 1 %
- Table Validator (Reference)< 1 %
- Missing Value Column Filter< 1 %
- Rank< 1 %
- Cache< 1 %
- DB Row Filter< 1 %
- DB Data Spec Extractor< 1 %
- Path to String< 1 %
- String to Date/Time (legacy)< 1 %
- Variable to Table Row< 1 %
- Missing Value (Apply)< 1 %
- Breakpoint< 1 %
- Cell Splitter By Position< 1 %
- ORC Reader< 1 %
- H2O MOJO Predictor (Classification)< 1 %
- Multiple Selection Configuration< 1 %
- Reference Database Table Exists IF Switch (Legacy)< 1 %
- Strings to Binary Objects< 1 %
- Loop End (Column Append)< 1 %
Counting Loop Start< 1 %- Create Table Structure< 1 %
- Domain Calculator< 1 %
- Number to String (PMML)< 1 %
- Reference Column Resorter< 1 %
- String Input (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
Database Drop Table< 1 %Generic Loop Start< 1 %- Expand Bit Vector< 1 %
Cell Replacer< 1 %- Filter Apply< 1 %
- Nominal Value Row Filter< 1 %
- Rule Engine Variable< 1 %
- Spark to Hive< 1 %
- Spark to Table< 1 %
- SDF Stripper< 1 %
- DB Type Mapper< 1 %
- Counter Generation< 1 %
- Strings to Document< 1 %
- List Files/Folders< 1 %
- Boolean Configuration< 1 %
- Boolean Widget< 1 %
- String Widget< 1 %
- String to JSON< 1 %
- Disturber Node< 1 %
- Date&Time to legacy Date&Time< 1 %
- Date Field Extractor (legacy)< 1 %
Views
- This node has no views
Workflows
00_Setup_Hive_TableKNIME Hub- 00_Setup_Hive_TableKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- Show all 222 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.