Reproducible query — Product (shared drive)

SUM SECTIONS SECTION_INDEX

Anyone opening this link re-runs the same query against epoch 3, so it returns the same answer — that is what makes a number in a report checkable later.

50total SECTION_INDEX across 36 of 36 rows

epoch 3source gdrive:sectionsas of 2026-10-21T16:14:58Ztransforms type-coercioncache hit

Raw envelope — what an app or agent receives

{
  "ok": true,
  "query": null,
  "verb": "SUM",
  "subject": "SECTIONS",
  "data": {
    "sum": 50,
    "field": "SECTION_INDEX",
    "rows_considered": 36,
    "rows_contributing": 36,
    "rows_missing_value": 0
  },
  "_meta": {
    "epoch": 3,
    "provenance": {
      "source": "gdrive:sections",
      "sync_id": "sync-b8e6ade734",
      "source_freshness": "2026-10-21T16:14:58Z",
      "representation_freshness": "2026-10-21T16:14:58Z",
      "resolved_fields": [],
      "transforms": [
        "type-coercion"
      ]
    },
    "related": [
      "COUNT SECTIONS BY ID"
    ],
    "hints": [],
    "completeness": {
      "rows_considered": 36,
      "rows_contributing": 36,
      "rows_missing_value": 0,
      "complete": true
    },
    "cache": "hit"
  }
}

Certificate · Playground · What you can ask