Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Table Creator
NodeNode / Source

DB Table Creator

DB Utility
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: DB Session
    DB Input
    DB Connection to connect to the database.
Output ports
  1. Type: DB Session
    DB Output
    Input DB Connection that can be changed to DB Data referencing the selected database table.
KNIME Data Table (Dynamic Inport)
An optional KNIME data table whose data table specification could be used to create the new database table.
  1. Type: Table
KNIME Data Table (Dynamic Outport)
The unaltered input KNIME data table to be used in subsequent nodes.
  1. Type: Table

Extension

The DB Table Creator node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    03.0_Setup_Local_Big_Data_Environment
    Education Data engineering Data engineer
    +3
    This workflow sets up a local big data environment for the next exercise. It creates a lo…
    hayasaka > KNIME Fall Summit Training 2022 > L4-DE Best Practices for Data Engineering > solutions > Session_3_ELT_on_Big_Data > 03.0_Setup_Local_Big_Data_Environment
    hayasaka
  2. Go to item
    03.0_Setup_Local_Big_Data_Environment
    Education Data engineering Data engineer
    +3
    This workflow sets up a local big data environment for the next exercise. It creates a lo…
    hayasaka > KNIME Fall Summit Training 2022 > L4-DE Best Practices for Data Engineering > exercises > Session_3_ELT_on_Big_Data > 03.0_Setup_Local_Big_Data_Environment
    hayasaka
  3. Go to item
    03.0_Setup_Local_Big_Data_Environment
    Education Data engineering Data engineer
    +3
    This workflow sets up a local big data environment for the next exercise. It creates a lo…
    chemgirl36 > Public Space > L4-DE Best Practices for Data Engineering > solutions > Session_3_ELT_on_Big_Data > 03.0_Setup_Local_Big_Data_Environment
    chemgirl36
  4. Go to item
    03.0_Setup_Local_Big_Data_Environment
    Education Data engineering Data engineer
    +3
    This workflow sets up a local big data environment for the next exercise. It creates a lo…
    chemgirl36 > Public Space > L4-DE Best Practices for Data Engineering > exercises > Session_3_ELT_on_Big_Data > 03.0_Setup_Local_Big_Data_Environment
    chemgirl36
  5. Go to item
    03.0_Setup_Local_Big_Data_Environment
    Education Data engineering Data engineer
    +3
    This workflow sets up a local big data environment for the next exercise. It creates a lo…
    knime > Education > Courses > L4-DE Best Practices for Data Engineering > exercises > Session_3_ELT_on_Big_Data > 03.0_Setup_Local_Big_Data_Environment
    knime
  6. Go to item
    03.0_Setup_Local_Big_Data_Environment
    Education Data engineering Data engineer
    +3
    This workflow sets up a local big data environment for the next exercise. It creates a lo…
    knime > Education > Courses > L4-DE Best Practices for Data Engineering > solutions > Session_3_ELT_on_Big_Data > 03.0_Setup_Local_Big_Data_Environment
    knime
  7. Go to item
    02 Getting Started with Big Data - Solution
    Big data Create local big data environment Hive
    Solution to an L4-BD SELF-PACED COURSE exercise: - Create a local big data environment - …
    knime > Education > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Solutions > 02 Getting Started with Big Data - Solution
    knime
  8. Go to item
    03 Manipulating Big Data
    Big data Spark Hive
    L4-BD SELF-PACED COURSE exercise: - Manipulate data on Hive with the DB nodes - Perform E…
    knime > Education > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Exercises > 03 Manipulating Big Data
    knime
  9. Go to item
    02 Getting Started with Big Data - Solution
    Big data Create local big data environment Hive
    Solution to an L4-BD SELF-PACED COURSE exercise: - Create a local big data environment - …
    tqthanh168 > Public > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Solutions > 02 Getting Started with Big Data - Solution
    tqthanh168
  10. Go to item
    03 Manipulating Big Data
    Big data Spark Hive
    L4-BD SELF-PACED COURSE exercise: - Manipulate data on Hive with the DB nodes - Perform E…
    tqthanh168 > Public > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Exercises > 03 Manipulating Big Data
    tqthanh168

No known nodes available

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits