{"id":"table-decimal-group-cube","version":"1.0.0","description":"Sum exact decimal strings over deterministic SQL CUBE grouping sets with explicit subtotal markers.","supported_operations":["cube decimal table by dimensions","grouped cube for json rows","exact decimal cube table","sql cube over table","bounded grouped cube","deterministic cube groups"],"unsupported_operations":["parse CSV text","floating-point measures","more than six dimensions"],"semantics":["Dimensions are compared as exact well-formed strings; missing and null are the same data-null group.","Generated subtotal cells use subtotal true, while data null cells use subtotal false.","Grouping sets are emitted in structural order; within each set null sorts before strings and strings sort by Unicode code point.","Decimal addition is exact and output is canonical base 10 without exponent or negative zero.","The output is capped at 50000 group rows and 16777216 UTF-8 bytes."],"limits":{"max_input_bytes":16777216,"max_rows":10000,"max_dimensions":6,"max_columns_per_row":16,"max_field_bytes":64,"max_decimal_bytes":256,"max_output_rows":50000,"max_output_bytes":16777216},"pricing":{"status":"unpriced","charge_usd":null},"input_schema":{"type":"object","additionalProperties":false,"required":["rows","dimensions","measure"],"properties":{"rows":{"type":"array","maxItems":10000,"items":{"type":"object","additionalProperties":{"type":["string","null"]},"maxProperties":16}},"dimensions":{"type":"array","minItems":1,"maxItems":6,"uniqueItems":true,"items":{"type":"string","minLength":1,"maxLength":64}},"measure":{"type":"string","minLength":1,"maxLength":64}}},"output_schema":{"type":"object","additionalProperties":false,"required":["standard_version","groups"],"properties":{"standard_version":{"type":"string","const":"ISO/IEC 9075-2:2016"},"groups":{"type":"array","maxItems":50000,"items":{"type":"object","additionalProperties":false,"required":["dimensions","count","sum"],"properties":{"dimensions":{"type":"array","maxItems":6,"items":{"type":"object","additionalProperties":false,"required":["value","subtotal"],"properties":{"value":{"type":["string","null"]},"subtotal":{"type":"boolean"}}}},"count":{"type":"integer","minimum":0,"maximum":10000},"sum":{"type":"string","pattern":"^-?(0|[1-9][0-9]*)(\\.[0-9]+)?$"}}}}}},"examples":[{"input":{"rows":[{"region":"east","amount":"1.1"},{"region":"east","amount":"2.2"}],"dimensions":["region"],"measure":"amount"},"output":{"standard_version":"ISO/IEC 9075-2:2016","groups":[{"dimensions":[{"value":"east","subtotal":false}],"count":2,"sum":"3.3"},{"dimensions":[{"value":null,"subtotal":true}],"count":2,"sum":"3.3"}]}},{"input":{"rows":[{"region":null,"amount":"2.0"}],"dimensions":["region"],"measure":"amount"},"output":{"standard_version":"ISO/IEC 9075-2:2016","groups":[{"dimensions":[{"value":null,"subtotal":false}],"count":1,"sum":"2"},{"dimensions":[{"value":null,"subtotal":true}],"count":1,"sum":"2"}]}}],"execute_url":"/v1/tools/table-decimal-group-cube/versions/1.0.0/execute"}