{"title":"DB Writer (DB Data)","nodeType":"Sink","id":"*Ts6MTyaKUWegubym","factoryName":"org.knime.database.node.connector.tablewriter.DBConnectionTableWriterNodeFactory","factoryId":"org.knime.database.node.connector.tablewriter.DBConnectionTableWriterNodeFactory","path":["DB","Utility"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Writes the table from the input database connection into a new table inside the database.</p>\n        ","shortDescription":"Writes the input database table into a new database table.","keywords":["database","copy","write","db"],"deprecated":false,"streamable":true,"tags":["DB","Utility","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6N0IwRTNGN0U4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6N0IwRTNGN0Q4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpDMUFFOTI3RTgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpDMUFFOTI3RjgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PqdguOcAAAEeSURBVHjalNM9SwNBEIDhiYYYO4tUQUsLAwb/glhEErS1TWcRiFgY0FbEj4A/w1IEEyNob2eVSkvBRuzEjwSM74Qp1mUvd7fwcHezO7N7c4mIyDMu0UBBokceP3b9N0aOT9S9+Rvs4NTWtNFEL1RAfXgFmhbvooWOPWtRyQaO2nbuZzFvp6hZ7AzXFtd5GeIR51j2in3bbi0vvmdxzZWpCY3L4QS3yDjxnsVzmvzrTCziyHke4A0VS9q3YusWH2jVbZSxiiVLdHe7wh2KOMAxXlDFRugrvEe8zgy+4n4H9yhJynGILSzErBslLViOSA4W0GbNWdIaNrHiNXHizpnAAv2s02mO7jZRu7yb5hX0v/CEPh5wgdeEJx2PPwEGAAlQTbkk42X5AAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data to write","description":"DB Data referencing the data to write."}],"outPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data","description":"DB Data referencing the database table the data was inserted into."}],"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 optional database schema name.","optional":false},{"name":"Table name","description":"The table name to append or create.","optional":false},{"name":"If 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>Overwrite</b> : Overwrites an existing database table. All previous data will be deleted.</li><li><b>Append</b> : All data rows will be appended to an existing database table. All previous data will be preserved.</li><li><b>Fail</b> : The node will fail if a table with the same name already exists in the database.</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":[{"id":"*d8TQIqNnO3XRVTjQ","factoryName":"org.knime.database.node.io.reader.DBReadNodeFactory","probability":0.6666666666666666},{"id":"*5nnLXgQCDPb0sDP1","factoryName":"org.knime.database.node.manipulation.filter.row.DBFilterRowNodeFactory","probability":0.3333333333333333}]}