{"id":"table-decimal-group-count","version":"1.0.0","description":"Count rows by exact string-valued dimensions with stable, bounded grouping output.","supported_operations":["count decimal table by dimensions","grouped count for json rows","exact decimal count table","sql count over table","bounded grouped count","deterministic count 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"],"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}}}},"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"],"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}}}}}},"examples":[{"input":{"rows":[{"region":"east"},{"region":"east"}],"dimensions":["region"]},"output":{"standard_version":"ISO/IEC 9075-2:2016","groups":[{"dimensions":[{"value":"east","subtotal":false}],"count":2}]}},{"input":{"rows":[{"region":null}],"dimensions":["region"]},"output":{"standard_version":"ISO/IEC 9075-2:2016","groups":[{"dimensions":[{"value":null,"subtotal":false}],"count":1}]}}],"execute_url":"/v1/tools/table-decimal-group-count/versions/1.0.0/execute"}