{"title":"DB Table Structure Creator","nodeType":"Source","id":"*VBVzgyQJs0k1k-yh","factoryName":"org.knime.database.node.utility.tablecreator3.DBTableCreate3NodeFactory","factoryId":"org.knime.database.node.utility.tablecreator3.DBTableCreate3NodeFactory","path":["DB","Utility"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node allows a user to create a new database table either manually or based on the specification of a KNIME input data table. 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.</p>\n             \n            <p>Connect a KNIME data table to use its specification to create the new database table. It is no longer possible to directly add or modify columns and keys in this mode, but column types and keys can be set dynamically instead. While in dynamic settings mode the &#34;Columns&#34; and &#34;Keys&#34; section become read-only to allow you a preview of the dynamic settings.</p>\n            \n        \n        ","shortDescription":"This node allows a user to create a new database table either manually or\n based on the data table specification of a KNIME input data table.","keywords":["database","db","create","table"],"deprecated":false,"streamable":true,"tags":["DB","Utility","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAN1wAADdcBQiibeAAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAACsSURBVDiNpdE9DkFBFMXx3/MZhURUOp1KrbELFauwHp1YgQaxBFsgEa1CISGhEApevIhHhpOcYnLn/u+5M/ypLJbooYUIq1DI9cWzB+hnwB6lXwBnTNAMaYYu2iiHNiYVoY4+FqiENK9w8lzl6P0jxvXUQuxpyqCvgA0GqIUCqigkziXkU9K9WgYXNNDBCFsUU1J8jBZ7F7JC5s3Fccj0HNY4uH/nHMMQwN+6AbjLO59QfduWAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"DB Input","description":"DB Connection to connect to the database."}],"outPorts":[{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"DB Output","description":"Input DB Connection that can be changed to DB Data referencing the selected database table."}],"dynInPorts":[{"groupName":"KNIME Data Table","groupDescription":"An optional KNIME data table whose data table specification is used to create the new database table.","types":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table"}]}],"dynOutPorts":[{"groupName":"KNIME Data Table","groupDescription":"The unaltered input KNIME data table to be used in subsequent nodes.","types":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table"}]}],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Database name","description":"The name of the database (or catalogue) to use.","optional":false},{"name":"Schema name","description":"The database schema to read the table from. If not provided, the default schema of the database will be used.","optional":false},{"name":"Table name","description":"Name of the database table to read data from. Must match the table name as it appears in the selected schema.","optional":false},{"name":"Create temporary table","description":"If checked, a temporary table is created. The scope of the created table and time it exists depends on the database specific handling of temporary tables.","optional":false},{"name":"If the database table exists","description":"If no table with the given name exists in the database a new table will be created. However if a table with the entered name already exists in the database, one of the following operations is performed depending on the selected option:\n<ul><li><b>Replace existing table</b> : Overwrites an existing database table. All previous data will be deleted.</li><li><b>Execute without changing existing table</b> : The node will not change the table.</li><li><b>Fail during execution</b> : The node will fail if a table with the same name already exists in the database.</li></ul>","optional":false},{"name":"Columns","description":"<ul><li><b>Column name</b> : The name of the column.</li><li><b>Column type</b> : The type of the column.</li><li><b>Not null</b> : If checked, the column cannot be null.</li></ul>","optional":false},{"name":"Name-based SQL type mapping","description":"<p>In the Name-Based SQL Type Mapping, a user can define the default SQL type mapping for a set of columns based on the column names. Use the &#34;Add&#34; button to add a new row containing the name pattern of the columns that should be mapped. The name pattern can either be a string with wildcard or a regular expression. The mappings defined in the <b>Name-Based SQL Type Mapping</b> have a <b>higher priority</b> than the mappings defined in the KNIME-Based SQL Type Mapping.</p>\n<ul><li><b>Name pattern</b> : The name pattern of the columns.</li><li><b>Pattern type</b> : Choose how the match columns.\n  <ul><li><b>Regex</b> : Use a regex expressions to select multiple columns.</li><li><b>Wildcard</b> : Use a string with wildcard expressions. Supported wildcards are &#39;*&#39; (matches zero or more characters) and &#39;?&#39; (matches exactly one character).</li></ul></li><li><b>SQL type</b> : The SQL type that should be mapped to the columns.</li><li><b>Not null</b> : If checked, the column cannot be null.</li></ul>","optional":false},{"name":"KNIME-Based SQL type mapping","description":"<p>In the KNIME-Based SQL Type Mapping, a user can define the default SQL type mapping based on KNIME data type. The mappings defined in the <b>KNIME-Based SQL Type Mapping</b> have a <b>lower priority</b> than the mappings defined in the Name-Based SQL Type Mapping.</p>\n<ul><li><b>KNIME type</b> : KNIME type the columns should be mapped from.</li><li><b>SQL type</b> : The SQL type that should be mapped to the columns.</li><li><b>Not null</b> : If checked, the column cannot be null.</li></ul>","optional":false},{"name":"Columns preview","description":"<ul><li><b>Column name</b> : The name of the column.</li><li><b>Column type</b> : The type of the column.</li><li><b>Not null</b> : If checked, the column cannot be null.</li></ul>","optional":false},{"name":"Keys","description":"<ul><li><b>Key name</b> : The name of the key.</li><li><b>Key column</b> : The columns used to define the key.</li><li><b>Primary key</b> : If checked, the key is a primary key. Otherwise, it is a unique key.</li></ul>","optional":false},{"name":"Dynamic keys","description":"The Dynamic Keys Settings can be used to dynamically define the key definitions based on the column names.\n<ul><li><b>Name pattern</b> : The name pattern of the columns.</li><li><b>Pattern type</b> : Choose how to match columns.\n  <ul><li><b>Regex</b> : Use a regex expressions to select multiple columns.</li><li><b>Wildcard</b> : Use a string with wildcard expressions. Supported wildcards are &#39;*&#39; (matches zero or more characters) and &#39;?&#39; (matches exactly one character).</li></ul></li><li><b>Key name</b> : The name of the key.</li><li><b>Primary key</b> : If checked, the key is a primary key. Otherwise, it is a unique key.</li></ul>","optional":false},{"name":"Keys preview","description":"<ul><li><b>Key name</b> : The name of the key.</li><li><b>Key column</b> : The columns used to define the key.</li><li><b>Primary key</b> : If checked, the key is a primary key. Otherwise, it is a unique key.</li></ul>","optional":false},{"name":"SQL statement","description":"The SQL statement to append after the regular create table statement e.g., DB specific storage information. The statement gets simply appended at the end of the automatically generated create table statement and executed as a single statement.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171318","bundleName":"KNIME database nodes","bundleSymbolicName":"org.knime.database.nodes","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.database","featureName":"KNIME Database","featureVersion":"5.12.0.v202606171318","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*0mIkLShcIfCXS7Y-"},"frequentSuccessors":[]}