{"api_version":2,"name":"galaxy_sql_quantile_buckets","version":"1.0","role":"transform","type":"sdk","description":"Assign rows to approximately equal-sized ordered buckets.","icon":{"path":"M4 3h12l4 4v14H4zM8 11h8M8 15h8m-8 4h5"},"inputs":{"source":{"representations":["bytes"],"formats":[]}},"outputs":{"result":{"view":"bytes"}},"parameters":{"type":"object","properties":{"key_column":{"type":"integer","default":1,"minimum":1,"maximum":256,"description":"One-based key column of each TSV input."},"value_column":{"type":"integer","default":2,"minimum":1,"maximum":256,"description":"One-based primary numeric column."},"second_column":{"type":"integer","default":0,"minimum":0,"maximum":256,"description":"One-based optional secondary numeric column; zero supplies NULL."},"header":{"type":"boolean","default":false,"description":"Skip the first row of each TSV input."},"buckets":{"type":"integer","default":2,"minimum":1,"maximum":256,"description":"Number of ordered buckets."}},"additionalProperties":false,"required":[]},"documentation":{"inputs":{"source":"One TSV bytes stream. Runs a fixed SQLite query over bounded headerless TSV inputs. The key column is text; selected value columns contain finite numbers or NA. A header row labels the result. The header parameter can skip an input header. Named columns are projected in the documented order."},"outputs":{"result":"TSV bytes. Runs a fixed SQLite query over bounded headerless TSV inputs. The key column is text; selected value columns contain finite numbers or NA. A header row labels the result. The header parameter can skip an input header. Named columns are projected in the documented order."},"parameters":{"key_column":{"description":"One-based key column of each TSV input.","help":"One-based key column of each TSV input.","example":1},"value_column":{"description":"One-based primary numeric column.","help":"One-based primary numeric column.","example":2},"second_column":{"description":"One-based optional secondary numeric column; zero supplies NULL.","help":"One-based optional secondary numeric column; zero supplies NULL.","example":0},"header":{"description":"Skip the first row of each TSV input.","help":"Skip the first row of each TSV input.","example":false},"buckets":{"description":"Number of ordered buckets.","help":"Number of ordered buckets.","example":2}},"example_job":"name: Assign rows to approximately equal-sized ordered buckets.\nsteps:\n- id: read_source\n  operator: item_source@1.0\n  inputs: {}\n  params:\n    uri: context:/galaxy/sql_quantile_buckets-source.tsv\n    view: bytes\n- id: process\n  operator: galaxy_sql_quantile_buckets@1.0\n  inputs:\n    source: read_source\n  params:\n    key_column: 1\n    value_column: 2\n    second_column: 0\n    header: false\n    buckets: 2\n- id: client_sink\n  operator: client_sink@1.0\n  inputs:\n    result: process\n"},"execution":{"executor":"python","entrypoint":"galaxy_sql_quantile_buckets","config":{}},"source_public":true,"runtime":{"image":"sha256:40db7fee594f1452790d1cc99c2e5429e187eb64633c716b8c6f903c47576975","archive":{"sha256":"e1844833e35390f2eaf9fc9ec7b67057ad0305ad713c0da6c8b055980a66946c","size":73825792,"filename":"python-arrow-2.0-runtime.tar"}},"provenance":{"source_archive":{"sha256":"ce212541c393c394274169e38f88101b9d2c5951844b1722b06bfba786ae9ad0","size":35701,"filename":"galaxy_sql_quantile_buckets-sources.zip"},"source_repository":"https://github.com/galaxyproject/tools-iuc","source_revision":"a9914e6c25a7aee16191a11c654ea25d72d0017c","license":"AFL-3.0 AND MIT","license_file":{"sha256":"06276304c423a835d843f55c62288aee7e5d6e474f301fe51a6e78481c39ca5b","size":1077,"filename":"GALAXY-LICENSE.txt"},"build_instructions":"Compile src/*.py with the python-arrow@2.0 builder. Execute with the registered python-arrow@2.0 runtime. See upstream-manifest.json and fixtures.json for evidence."},"artifact":{"sha256":"856988be56b6c28fcc11a8b1767eed8ab3305199c09ec094146e8fb00e24a2b6","size":13382,"filename":"operator.zip"},"categories":["Galaxy","SQL","Tabular data"],"trust":{"score":4,"assessed_by":"administrator","reviewed_at_ms":1795075854270},"publication":{"author":"dacp-examples","submitted_at_ms":1795075848335,"approved_at_ms":1795075854270,"last_submitted_at_ms":1795075848335,"last_approved_at_ms":1795075854270},"download_count":3}