Reproducible query — Product (shared drive)
COUNT PERMISSIONS BY PRINCIPAL
Anyone opening this link re-runs the same query against epoch 1, so it returns the same answer — that is what makes a number in a report checkable later.
| acme.com | 20 65% |
| dana@vendor.io | 3 10% |
| alice@acme.com | 2 6% |
| bob@acme.com | 2 6% |
| carol@acme.com | 2 6% |
| anyone | 1 3% |
| eng@acme.com | 1 3% |
7 groups · 31 rows total
epoch 1source gdrive:permissionsas of 2026-09-14T21:44:11Ztransforms type-coercioncache hit
Raw envelope — what an app or agent receives
{
"ok": true,
"query": null,
"verb": "COUNT",
"subject": "PERMISSIONS",
"data": {
"groups": [
{
"group": "acme.com",
"count": 20
},
{
"group": "dana@vendor.io",
"count": 3
},
{
"group": "alice@acme.com",
"count": 2
},
{
"group": "bob@acme.com",
"count": 2
},
{
"group": "carol@acme.com",
"count": 2
},
{
"group": "anyone",
"count": 1
},
{
"group": "eng@acme.com",
"count": 1
}
],
"total": 31
},
"_meta": {
"epoch": 1,
"provenance": {
"source": "gdrive:permissions",
"sync_id": "sync-fbaf01faca",
"source_freshness": "2026-09-14T21:44:11Z",
"representation_freshness": "2026-09-14T21:44:11Z",
"resolved_fields": [],
"transforms": [
"type-coercion"
]
},
"related": [
"SUM PERMISSIONS ? BY PRINCIPAL",
"LIST PERMISSIONS LIMIT 10"
],
"hints": [],
"cache": "hit"
}
}