{"title":"DB Data Spec Extractor","nodeType":"Manipulator","id":"*mWe5bs8HqRo2SN9_","factoryName":"org.knime.database.node.utility.specextractor.DBDataSpecExtractorNodeFactory","factoryId":"org.knime.database.node.utility.specextractor.DBDataSpecExtractorNodeFactory","path":["DB","Utility"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node reads the schema information from the input DB Data port and outputs it as a KNIME data table. The extracted information includes column name, data type, and column order.</p>\n        ","shortDescription":"Extracts the column specification from a DB Data input port.","keywords":["database","db","schema","header","columns","metadata","specification"],"deprecated":false,"streamable":false,"tags":["DB","Utility"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7yAAAO8gHOFHveAAAAGXRFWHRTb2Z0d2FyZQB3d3cuaW5rc2NhcGUub3Jnm+48GgAAAOFJREFUOI210TFLA0EQBeBPUUIIamUsrGxstbGzSmERLC38DRZamU683xH9FyLWFhZpEqxtUoqNICIEi7NwT5LN3nGCPliWefN485jhj3CGR9yih82E5gobZQYZ8qn3hoNIk+M9aBsFuVhiuIK9BN/COY6qEoyDaDmR4AZbqYk76GK7JBEcVvR+0EQH17hM9IuUczjBi9lF9uoYLIW/jfVIfJ8wWIiJ+AofeMAxBhUJduNGE2sRt1rHoEjwGQz2fZ9whIuEQSkyswvMcfqbBDEmuKszubjCK57wjCH6of5/fAHUXTVcxJA6jgAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data","description":"DB Data with the database query to extract."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"DB Data Specification","description":"The DB data specification from the input DB Data port."}],"dynInPorts":[],"dynOutPorts":[],"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":"Format of KNIME Type Names","description":"Determines how the types of columns are represented in the output table. The following options are available:\n<ul><li>Identifier: The type names are represented with a unique identifier. This is the recommended option.</li><li>Legacy Display Name: The type names are represented by their old display name. This option is intended to be used purely for backwards-compatibility.</li><li>Display Name: The type names are represented by their display name. This name may change at any point with an update, so it is highly discouraged to match against this output in any way.</li></ul>","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:0e6274e1-0c93-4240-bb66-636e78eb2162","user":"mlauber71","date":"2026-01-06T08:34:57+00:00"}],"kudosCount":1,"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":[]}