{"title":"DB Table Selector","nodeType":"Source","id":"*O5R1MUoKdUYMSY-I","factoryName":"org.knime.database.node.utility.tableselector.DBTableSelectNodeFactory2","factoryId":"org.knime.database.node.utility.tableselector.DBTableSelectNodeFactory2","path":["DB","Query"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node takes a DB Connection as input and allows to select a table or view from within the connected database. The node outputs a DB Data object which contains the database connection information as well as a database query that defines the data in the database.\n <br />\n In addition, this node allows to enter a customized SELECT statement which is then propagated to all connected nodes.</p>\n        ","shortDescription":"Selects a table from a database connection","keywords":[],"deprecated":false,"streamable":true,"tags":["DB","Query","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6ODc1QzREQkI4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6ODc1QzREQkE4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpFMUNDOEYxNzgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpFMUNDOEYxODgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PgunuAIAAADaSURBVHjaYmRgYLgNxJeBeC8Qr/z///8bBhLBfyT8DYgTgIYwEIsZoRqRwVegBA+5LgDhenRbgOA8EF8FYhUscgy/gfgcEPcBsS42ZwLBJajht4BYDd0AJkL+BAJFIL4INeQGEGvC5dAUqgJxKw5DVID4AtQQkHc0YC5IB+KpQHwNFg54XCILdQHYJTAD0APxLSUG7AFiLSK8cA3ZC81AHA4yneJAhCrWIzUaBYDYDogboQnmPykJCVtS/geUYCY3KX8H4kJSM9NNIL4CxMeBeBlQ8BkptgMEGACiYoogFsgNkgAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"DB session","description":"DB connection to connect to the database."}],"outPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB table","description":"DB Data referencing the data in the database."}],"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":"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":"Custom query","description":"An input field to enter the <i>SELECT</i> statement that should be propagated to all connected nodes. Optionally, the <i>#table#</i> placeholder can be used to refer to the table or view selected above.","optional":false},{"name":"Name","description":"Columns that match the given name (or regular expression) and database type will be mapped to the specified KNIME type.\n<ul><li><b>Column selection type</b> : The option allows you to select how the column is matched.\n  <ul><li><b>Manual</b> : Use the exact name of the column</li><li><b>Regex</b> : Allow regex expressions to select multiple columns</li></ul></li><li><b>Column name</b> : The name or regex expression.</li><li><b>Database type</b> : SQL type to map from.</li><li><b>Mapping to</b> : Datatype to map to.</li></ul>","optional":false},{"name":"Type","description":"Columns that match the given database type will be mapped to the specified KNIME type.\n<ul><li><b>From type</b> : SQL type to map from.</li><li><b>To type</b> : Datatype to map to.</li></ul>","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":[]}