HALOWERKFinopswerk
query scan control charge ledger
Originalcompletedqueryscanfragments/statement/outcomecaptures determine scanned/rounded/minimumchargedMB plusstrictperquerylimit andcumulativeworkgroupalertcondition. OwnexplicitdecimalMB=1000000bytes;DDL/failedfree,canceledselectscanbilled;aggregatealarmdoesnotcancelqueries. NoSQL/cache/physicalscan/SNS/providerbill/prices/moneycertification. Oneboundedoutcomecapturekeeps2wholeworlds.Strictrecursive reportkeys/objectorderirrelevant/arraysordered. A schema-valid unknown is a successful.
POST https://finops.halowerk.com/v1/query-scan-control-charge-ledgerEingaben
| Feld | Typ | Pflicht | Beschreibung |
|---|---|---|---|
| queries | array | Ja | |
| query_limit_bytes | integer | Ja | |
| workgroup_threshold_bytes | integer | Ja | |
| report | object | Ja |
Vollständiges Eingabeschema anzeigen
{
"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
}Veröffentlichtes Eingabebeispiel
{
"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
}
}
}Ergebnis & Dokumentation
Maschinenlesbare Dokumentation dieses Hubs
Quelle dieser Seite: der veröffentlichte HALOWERK-Katalog. Stand: 2026-11-07, 02:42 UTC.
Weitere Endpunkte dieses Hubs
- Finopswerk0,003 USDC
acquisition goodwill nci bridge
POSThttps://finops.halowerk.com/v1/acquisition-goodwill-nci-bridgeReconstruct ONE acquisition-date business-combination goodwill/NCI bridge from already correctly recognized/measured identifiedassets,assumedliabilities,newcash/noncashconsideration and previouslyheldinterest. EligiblepresentownershipNCI mo
- Finopswerk0,003 USDC
adjusted coupon cashflow ledger
POSThttps://finops.halowerk.com/v1/adjusted-coupon-cashflow-ledgerOriginalcivilstart/tenor/EOM/principal/rateandexplicitcalendars deriveunadjustedaccrualanchors,Following/ModifiedFollowing/Precedingpaymentdates,ACT365Fexactinterestandlastprincipalredemption. OWNanchoredroll/composition;paymentadjustmentdo
- Finopswerk0,003 USDC
aged receivable loss allowance ledger
POSThttps://finops.halowerk.com/v1/aged-receivable-loss-allowance-ledgerReconstruct original receivable aging, four bucket exposures, two scenario loss arrays, probability-weighted allowance, net carrying values and signed adjustment to booked allowance. Caller supplies already-supported present-value-adjusted