{"title":"DB Row Sampler","nodeType":"Manipulator","id":"*4hFtwIsFE99gW1Q6","factoryName":"org.knime.database.node.manipulation.sampling.sampling.DBSampleNodeFactory","factoryId":"org.knime.database.node.manipulation.sampling.sampling.DBSampleNodeFactory","path":["DB","Query"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node extracts a sample from the input data. The dialog enables you to specify the sample size and the sampling strategy.</p>\n        ","shortDescription":"This node samples rows from a database table.","keywords":["DB Row Sampling","sample","sampling","database"],"deprecated":false,"streamable":true,"tags":["DB","Query","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAN1wAADdcBQiibeAAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAAEMSURBVDiNpdKxSsJRGAXwn39vhhAaNRRCtFRTaz1Ha0/Q6FP0DjUE0StERG0tQeDUpkIEDYKUFEnRELfBK8gfDa0DZzl8nHvO913+iSJa2McuCmjPahJzvExGeX0c++MM3lBGbDQa191u9zyE8IIqammmis28wRcusD1M1ul0YowxlkqlXtIW0iysoh9S/yfc433W/kMUsI467rA47Q6CwdbXMJ/MPtIetA53rFRKE19drt+GgI2cfjPScyoM4zzi2GA5o/pEFrPCJyxhNGcZcyGE5xjjUbPZPBtJNPYK39hK3EusZVmW4aBSqfwaP+A1p/WkDzIt8t1OJugTz/iQXmzjCqfJoDBLij/jB4MrdwYWwimkAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data to sample","description":"DB Data to apply sampling."}],"outPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"Sampled DB Data","description":"DB Data with sampled rows."}],"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":"Output size type","description":"Defines how the size of the output is specified: as a percentage of total rows (relative) or as an absolute number of rows.","optional":false},{"name":"Relative size","description":"Specifies the percentage of rows in the database table to extract. Must be between 0 and 100 (inclusive).","optional":false},{"name":"Number of rows","description":"Specifies the absolute number of rows to include in the output. If the input table contains fewer rows than specified, all rows are placed in the output.","optional":false},{"name":"Sampling strategy","description":"Determines how rows are selected for the output. Strategies include random, stratified, and first rows (sequential).\n<ul><li><b>Random</b> : Randomly selects rows from the input table if the connected database supports random sampling. <b>Note that this method might be very slow for large database tables</b> .</li><li><b>Stratified</b> : Preserves the distribution of values in the selected group column.</li><li><b>First rows</b> : Allows you to select the top-most rows of the input table. <b>Note that the order of the rows depends on the connected database.</b></li></ul>","optional":false},{"name":"Group column","description":"Specifies the column whose value distribution should be preserved in stratified sampling. Ensures both selected and non-selected rows reflect the same distribution of values.","optional":false},{"name":"Fixed random seed","description":"Optional seed value for random or stratified sampling. Using a seed ensures the same rows are selected each time the node is executed. Without a seed, a different random selection will occur each time.","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":"*eTH6FxdMQbNIhJqB","factoryName":"org.knime.database.node.manipulation.sorter.DBSortNodeFactory","probability":0.6666666666666666},{"id":"*d8TQIqNnO3XRVTjQ","factoryName":"org.knime.database.node.io.reader.DBReadNodeFactory","probability":0.3333333333333333}]}