`gmail.draft_details`

pass

Detailed metadata and payload for one Gmail draft.

Requires `id` from `gmail.drafts`. The default `format` is `full`,

id captured 2026-09-01 13:53:54Zmedian 7176 ms

Verdict: TRUE

All variants returned rows on ≥2 of 3 trials, 0 errors.

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	2	7144 ms	7176 ms	7209 ms	[2, 2]
list	2	7062 ms	7145 ms	7229 ms	[2, 2]
json-extract	2	7037 ms	7043 ms	7049 ms	[2, 2]
aggregate	2	6991 ms	7015 ms	7040 ms	[4, 4]
edge	2	6994 ms	7005 ms	7017 ms	[2, 2]

Latency per trial

minimalmedian 7176ms

scale: 0–7209 ms

listmedian 7145ms

scale: 0–7229 ms

json-extractmedian 7043ms

scale: 0–7049 ms

aggregatemedian 7015ms

scale: 0–7040 ms

edgemedian 7005ms

scale: 0–7017 ms

Probe variants — every command + output

minimal2 trials

min 7144ms · median 7176ms · max 7209ms · rows 2,2

smallest query

Command

SELECT id, subject, internal_date FROM gmail.draft_details WHERE id = 'r202087827712273659' LIMIT 1

Trials + output

trial 1·7209ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------+----------------------------------------------------------------------+----------------------+": "+---------------------+----------------------------------------------------------------------+----------------------+"
}

columns (1)

+---------------------+----------------------------------------------------------------------+----------------------+

trial 2·7144ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------+----------------------------------------------------------------------+----------------------+": "+---------------------+----------------------------------------------------------------------+----------------------+"
}

columns (1)

+---------------------+----------------------------------------------------------------------+----------------------+

list2 trials

min 7062ms · median 7145ms · max 7229ms · rows 2,2

draft body + meta

Command

SELECT id, subject, internal_date, thread_id FROM gmail.draft_details WHERE id = 'r202087827712273659' LIMIT 1

Trials + output

trial 1·7229ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------+----------------------------------------------------------------------+----------------------+------------------+": "+---------------------+----------------------------------------------------------------------+----------------------+------------------+"
}

columns (1)

+---------------------+----------------------------------------------------------------------+----------------------+------------------+

trial 2·7062ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------+----------------------------------------------------------------------+----------------------+------------------+": "+---------------------+----------------------------------------------------------------------+----------------------+------------------+"
}

columns (1)

+---------------------+----------------------------------------------------------------------+----------------------+------------------+

json-extract2 trials

min 7037ms · median 7043ms · max 7049ms · rows 2,2

typed JSON on raw + message

Command

SELECT id, subject, json_as_text(raw, 'id') AS raw_id, json_as_text(message, 'snippet') AS msg_snippet FROM gmail.draft_details WHERE id = 'r202087827712273659' LIMIT 1

Trials + output

trial 1·7037ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------+----------------------------------------------------------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+": "+---------------------+----------------------------------------------------------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+"
}

columns (1)

+---------------------+----------------------------------------------------------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

trial 2·7049ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------+----------------------------------------------------------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+": "+---------------------+----------------------------------------------------------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+"
}

columns (1)

aggregate2 trials

min 6991ms · median 7015ms · max 7040ms · rows 4,4

single-id count

Command

SELECT COUNT(*) AS n FROM gmail.draft_details WHERE id = 'r202087827712273659'

Trials + output

trial 1·6991ms·rows 4isError=false

First row (click to expand JSON)

{
  "+---+": "n"
}

columns (1)

+---+

trial 2·7040ms·rows 4isError=false

First row (click to expand JSON)

{
  "+---+": "n"
}

columns (1)

+---+

edge2 trials

min 6994ms · median 7005ms · max 7017ms · rows 2,2

edge: capped LIMIT

Command

SELECT id, subject FROM gmail.draft_details WHERE id = 'r202087827712273659' LIMIT 25

Trials + output

trial 1·6994ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------+----------------------------------------------------------------------+": "+---------------------+----------------------------------------------------------------------+"
}

columns (1)

+---------------------+----------------------------------------------------------------------+

trial 2·7017ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------+----------------------------------------------------------------------+": "+---------------------+----------------------------------------------------------------------+"
}

columns (1)

+---------------------+----------------------------------------------------------------------+

All returned rowsacross all non-errored trials · filterable · paginated

20 rows stored · 48 returned · page 1/1


-1	0	+---------------------+--------------------------------------------------------…	—	—	—	—
0	1	+---------------------+--------------------------------------------------------…	—	—	—	—
1	2	+---------------------+--------------------------------------------------------…	—	—	—	—
2	3	+---------------------+--------------------------------------------------------…	—	—	—	—
-1	4	—	+---------------------+--------------------------------------------------------…	—	—	—
0	5	—	+---------------------+--------------------------------------------------------…	—	—	—
1	6	—	+---------------------+--------------------------------------------------------…	—	—	—
2	7	—	+---------------------+--------------------------------------------------------…	—	—	—
-1	8	—	—	+---------------------+--------------------------------------------------------…	—	—
0	9	—	—	+---------------------+--------------------------------------------------------…	—	—
1	10	—	—	+---------------------+--------------------------------------------------------…	—	—
2	11	—	—	+---------------------+--------------------------------------------------------…	—	—
-1	12	—	—	—	n	—
0	13	—	—	—	n	—
1	14	—	—	—	n	—
2	15	—	—	—	n	—
-1	16	—	—	—	—	+---------------------+--------------------------------------------------------…
0	17	—	—	—	—	+---------------------+--------------------------------------------------------…
1	18	—	—	—	—	+---------------------+--------------------------------------------------------…
2	19	—	—	—	—	+---------------------+--------------------------------------------------------…

Column profile

1 columns actually returned by coral. Catalog claims "1 required filter(s)": "id". Click a column to drill in.

#	Column	Inferred type	Non-null	Nulls	Sample value(s)
1	+---------------------+----------------------------------------------------------------------+----------------------+	string	4	16	`"+---------------------+-------------------------------------"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	7209ms	2	ok	+---------------------+----------------------------------------------------------------------+----------------------+
minimal	t2	7144ms	2	ok	+---------------------+----------------------------------------------------------------------+----------------------+
list	t1	7229ms	2	ok	+---------------------+----------------------------------------------------------------------+----------------------+------------------+
list	t2	7062ms	2	ok	+---------------------+----------------------------------------------------------------------+----------------------+------------------+
json-extract	t1	7037ms	2	ok	+---------------------+----------------------------------------------------------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
json-extract	t2	7049ms	2	ok	+---------------------+----------------------------------------------------------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
aggregate	t1	6991ms	4	ok	+---+
aggregate	t2	7040ms	4	ok	+---+
edge	t1	6994ms	2	ok	+---------------------+----------------------------------------------------------------------+
edge	t2	7017ms	2	ok	+---------------------+----------------------------------------------------------------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires `id` from `gmail.drafts`. The default `format` is `full`,

Columns coral returned (1)

+---------------------+----------------------------------------------------------------------+----------------------+

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T13:53:54Z

JSON record: reports/gmail/tables/draft_details.json

first_run_at: 2026-09-01T13:53:54Z

last_retried_at: 2026-09-01T13:53:54Z

retry_count: 1

View version history →