Skip to content

ECO-DAT-DATA-012 — Unbounded analytics queries

  • Category: Data (DAT)
  • Family: Data (DATA)
  • Layer: Data
  • Tier: 3
  • Severity: warning
  • Tags: analytics, cost
  • Legacy ID: ECO-DATA-012

Summary

Unbounded queries cause runaway compute and unpredictable cost.

Rationale

Analytics engines will happily burn money unless bounded.

Impact

{
  "confidence": 0.75,
  "notes": "Common in BI and ad-hoc SQL.",
  "type": "cost"
}

Detection

{
  "languages": [
    "infra",
    "database"
  ],
  "method": "trace"
}

Remediation

{
  "guidance": "Add quotas, limits, and guardrails; require partition filters.",
  "tradeoffs": "May restrict ad-hoc exploration."
}

Ontology

{
  "system_layers": [
    "data"
  ]
}