{"title":"DB Query Reader","nodeType":"Source","id":"*QGIJwvJk9FCppQZY","factoryName":"org.knime.database.node.io.reader.query.DBQueryReaderNodeFactory","factoryId":"org.knime.database.node.io.reader.query.DBQueryReaderNodeFactory","path":["DB","Read/Write"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Executes an entered SQL query and returns the result as KNIME data table.</p>\n        ","shortDescription":"Executes an entered SQL query and returns the result as KNIME data table.","keywords":["database","db","sql"],"deprecated":false,"streamable":false,"tags":["DB","Read/Write"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6Njg1OUE1QjA4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6Njg1OUE1QUY4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo5M0Y0RDE3MDgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo5M0Y0RDE3MTgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PveG+TsAAACuSURBVHjaYmZgYLgNxI5ALALE94H4GwOJ4D8SBmlOoMQAEP5CimYmLGLdpLrgNxCfA+I+INYlVTMLELMD8T8yvM0I8wKyZlUgbiXBELAp6UCsB41KTagkI7pCUmLhLQF5FIweC3uB2BZNjBELhsuBArEFiK8A8TEgfkxCQDLiktAjNRoFoJqcgdgPiA3wmY7NgPdoYv8oSco/gLiEVC/cggbicSBeBsTPSDEAIMAAE9kvjpoezx8AAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"DB Connection","description":"DB Connection to the database."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"KNIME data table","description":"KNIME data table with the result from the database query."}],"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":"Settings","fields":[{"name":"SQL Statement","description":"SQL editor to enter the SQL statement that returns the result data. This node supports complex queries, but may not be used for anything but queries. It can be also used to execute none &#34;SELECT&#34; statements that return any data such as a &#34;DESCRIBE&#34; statement etc.\n<br />\nTo open code completion press <i>&lt;CTRL&gt; &#43; &lt;SPACE&gt;</i> . Table and columns names are only suggested if the metadata is available e.g. shown in the Database Metadata Browser. To perform undo press <i>&lt;CTRL&gt; &#43; Z</i> and for re-do <i>&lt;CTRL&gt; &#43; Y</i> .\n<br />\nIf the node consumes a lot of memory you might want to decrease the &#34;Fetch size&#34; in the &#34;Advanced&#34; tab of the corresponding connector node. The fetch size specifies how many rows are fetched from the database server into KNIME per network round trip. The higher the number the more memory is consumed. However the smaller the number the more network round trips are necessary to fetch large results. Also not all JDBC driver support this option and thus might ignore it.","optional":false},{"name":"Database Metadata Browser","description":"The Database Metadata Browser allows you to browse the database metadata and to select a table or view. Click the <i>Refresh</i> button at the bottom right to re-fetch the metadata from the database. The data is grouped by database schema and type e.g. view or table. By clicking on an entity it shows contained elements. If you click on a table or view the dialog will fetch the column names and types of the selected element. To select a table or view select the name and click <i>OK</i> or double click the element. To search for a particular table or view enter the name or parts of the name into the search field and click on the <i>Magnifying Glass</i> button or press <i>enter</i> .","optional":false},{"name":"Flow Variable List","description":"The list contains the flow variables that are currently available at the node input. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).","optional":false}]},{"sectionName":"Input Type Mapping","sectionDescription":"This option allows you to define rules to map from database types to KNIME types.","fields":[{"name":"Mapping by Name","description":"Columns that match the given name (or regular expression) and database type will be mapped to the specified KNIME type.","optional":false},{"name":"Mapping by Type","description":"Columns that match the given database type will be mapped to the specified KNIME type.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:a3553d44-9b0c-4b0e-8d0a-4320b5b550a6","user":"sonlam76","date":"2021-03-15T07:36:25+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":[{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.14285714285714285},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.14285714285714285},{"id":"*pOeK5_nFRj2oJkV9","factoryName":"org.knime.database.node.io.merge.DBMergeNodeFactory","probability":0.10714285714285714},{"id":"*LKxrCJihG46anH0Q","factoryName":"org.knime.base.node.preproc.filter.rowref.RowFilterRefNodeFactory","probability":0.07142857142857142},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.07142857142857142},{"id":"*ebLbPp7VLbV4apta","factoryName":"org.knime.base.node.preproc.pivot.Pivot2NodeFactory","probability":0.03571428571428571},{"id":"*HG3L-oE4gau2HJVb","factoryName":"org.knime.base.node.preproc.crossjoin.CrossJoinerNodeFactory","probability":0.03571428571428571},{"id":"*0vNGuKOukHEP84tE","factoryName":"org.knime.database.node.io.insert.DBInsertNodeFactory","probability":0.03571428571428571},{"id":"*kFdnfo9l-qCs_mRZ","factoryName":"org.knime.network.node.inserter.feature.MultiFeatureInserterNodeFactory","probability":0.03571428571428571},{"id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.03571428571428571}]}