{"service":"HALOWERK finopswerk","endpoint":"/v1/query-scan-control-charge-ledger","method":"POST","content_type":"application/json","inputSchema":{"type":"object","properties":{"queries":{"type":"array","items":{"type":"object","properties":{"kind":{"enum":["select","ddl"]},"outcome_domain":{"type":"array","items":{"enum":["success","failed","canceled"]},"minItems":1,"maxItems":2},"fragments_bytes":{"type":"array","items":{"type":"integer","minimum":0,"maximum":100000000},"minItems":1,"maxItems":8}},"required":["kind","outcome_domain","fragments_bytes"],"additionalProperties":false},"minItems":1,"maxItems":8},"query_limit_bytes":{"type":"integer","minimum":10000000,"maximum":1000000000},"workgroup_threshold_bytes":{"type":"integer","minimum":1,"maximum":1000000000},"report":{"type":"object","properties":{"queries":{"type":"array","items":{"type":"object","properties":{"scanned_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"rounded_mb":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"charged_mb":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"query_limit_exceeded":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"cumulative_scanned":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"workgroup_exceeded":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]}},"required":["scanned_bytes","rounded_mb","charged_mb","query_limit_exceeded","cumulative_scanned","workgroup_exceeded"],"additionalProperties":false},"minItems":1,"maxItems":8},"totals":{"type":"object","properties":{"scanned_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"charged_mb":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"overlimit_queries":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"workgroup_exceeded":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]}},"required":["scanned_bytes","charged_mb","overlimit_queries","workgroup_exceeded"],"additionalProperties":false}},"required":["queries","totals"],"additionalProperties":false}},"required":["queries","query_limit_bytes","workgroup_threshold_bytes","report"],"additionalProperties":false},"requestExample":{"queries":[{"kind":"select","outcome_domain":["success"],"fragments_bytes":[1]},{"kind":"select","outcome_domain":["failed"],"fragments_bytes":[10500000]},{"kind":"select","outcome_domain":["canceled"],"fragments_bytes":[10500000]},{"kind":"ddl","outcome_domain":["success"],"fragments_bytes":[0]}],"query_limit_bytes":100000000,"workgroup_threshold_bytes":7000000,"report":{"queries":[{"scanned_bytes":1,"rounded_mb":1,"charged_mb":10,"query_limit_exceeded":0,"cumulative_scanned":1,"workgroup_exceeded":0},{"scanned_bytes":10500000,"rounded_mb":11,"charged_mb":0,"query_limit_exceeded":0,"cumulative_scanned":10500001,"workgroup_exceeded":1},{"scanned_bytes":10500000,"rounded_mb":11,"charged_mb":11,"query_limit_exceeded":0,"cumulative_scanned":21000001,"workgroup_exceeded":1},{"scanned_bytes":0,"rounded_mb":0,"charged_mb":0,"query_limit_exceeded":0,"cumulative_scanned":21000001,"workgroup_exceeded":1}],"totals":{"scanned_bytes":21000001,"charged_mb":21,"overlimit_queries":0,"workgroup_exceeded":1}}},"operations":[{"method":"POST","inputSchema":{"type":"object","properties":{"queries":{"type":"array","items":{"type":"object","properties":{"kind":{"enum":["select","ddl"]},"outcome_domain":{"type":"array","items":{"enum":["success","failed","canceled"]},"minItems":1,"maxItems":2},"fragments_bytes":{"type":"array","items":{"type":"integer","minimum":0,"maximum":100000000},"minItems":1,"maxItems":8}},"required":["kind","outcome_domain","fragments_bytes"],"additionalProperties":false},"minItems":1,"maxItems":8},"query_limit_bytes":{"type":"integer","minimum":10000000,"maximum":1000000000},"workgroup_threshold_bytes":{"type":"integer","minimum":1,"maximum":1000000000},"report":{"type":"object","properties":{"queries":{"type":"array","items":{"type":"object","properties":{"scanned_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"rounded_mb":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"charged_mb":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"query_limit_exceeded":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"cumulative_scanned":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"workgroup_exceeded":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]}},"required":["scanned_bytes","rounded_mb","charged_mb","query_limit_exceeded","cumulative_scanned","workgroup_exceeded"],"additionalProperties":false},"minItems":1,"maxItems":8},"totals":{"type":"object","properties":{"scanned_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"charged_mb":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"overlimit_queries":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]},"workgroup_exceeded":{"anyOf":[{"type":"integer","minimum":0,"maximum":10000000000},{"type":"null"}]}},"required":["scanned_bytes","charged_mb","overlimit_queries","workgroup_exceeded"],"additionalProperties":false}},"required":["queries","totals"],"additionalProperties":false}},"required":["queries","query_limit_bytes","workgroup_threshold_bytes","report"],"additionalProperties":false},"requestExample":{"queries":[{"kind":"select","outcome_domain":["success"],"fragments_bytes":[1]},{"kind":"select","outcome_domain":["failed"],"fragments_bytes":[10500000]},{"kind":"select","outcome_domain":["canceled"],"fragments_bytes":[10500000]},{"kind":"ddl","outcome_domain":["success"],"fragments_bytes":[0]}],"query_limit_bytes":100000000,"workgroup_threshold_bytes":7000000,"report":{"queries":[{"scanned_bytes":1,"rounded_mb":1,"charged_mb":10,"query_limit_exceeded":0,"cumulative_scanned":1,"workgroup_exceeded":0},{"scanned_bytes":10500000,"rounded_mb":11,"charged_mb":0,"query_limit_exceeded":0,"cumulative_scanned":10500001,"workgroup_exceeded":1},{"scanned_bytes":10500000,"rounded_mb":11,"charged_mb":11,"query_limit_exceeded":0,"cumulative_scanned":21000001,"workgroup_exceeded":1},{"scanned_bytes":0,"rounded_mb":0,"charged_mb":0,"query_limit_exceeded":0,"cumulative_scanned":21000001,"workgroup_exceeded":1}],"totals":{"scanned_bytes":21000001,"charged_mb":21,"overlimit_queries":0,"workgroup_exceeded":1}}}}]}