`gmail.message_attachments`

pass

Attachment body data for one Gmail message attachment.

Requires `message_id` and `attachment_id`. Attachment IDs are exposed

message_id, attachment_id captured 2026-09-01 17:06:32Zmedian 9654 ms

Verdict: TRUE

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

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
real-id-shape	2	9200 ms	9654 ms	10108 ms	[2, 2]
aggregate	2	9516 ms	10172 ms	10829 ms	[4, 4]
json-extract	2	7141 ms	7409 ms	7678 ms	[2, 2]
edge	2	7090 ms	7256 ms	7422 ms	[2, 2]

Latency per trial

real-id-shapemedian 9654ms

scale: 0–10108 ms

aggregatemedian 10172ms

scale: 0–10829 ms

json-extractmedian 7409ms

scale: 0–7678 ms

edgemedian 7256ms

scale: 0–7422 ms

Probe variants — every command + output

real-id-shape2 trials

min 9200ms · median 9654ms · max 10108ms · rows 2,2

real DigitalOcean invoice attachment — should return size 82541

Command

SELECT message_id, attachment_id, size FROM gmail.message_attachments WHERE attachment_id = 'ANGjdJ-Kl_YrYF92wRPJ3FhWiiaHB8EaA_YrKQUCBGmnKfH0l3eECpEh0dBGg3B6f0QOR87OW1M_Z8LvvfZHQt4ZNZK3yLO4Osjwge0Kj-0Ccmptb7o-CREJGww-bBUPv_XQtKIh0dZITVVx28FLQoSXKt99xSwrgTcC99BRPlYXXg6reMflEsTbA9_B2QLPi4khxeslOEsbvwQQPqXWdo6b4A1eY7OzaeqJkIhL9mWXxT-Y206tWkm07FcoREejP2-8AKCXiEyVwIKjaHePhN7jmjpH2azZC9QU4zvRjmi16sKaEq8Q49E4vVZCSAHxJnMMkeFaNFviifnp0nWwb5QXdKDXpYWkU-APWa50yemPxzMfyoeTkW08EaXtkibjNINVyIbR_lpb6Q4419Vy' AND message_id = '1a05c918ce469e58' LIMIT 1

Trials + output

trial 1·9200ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·10108ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

aggregate2 trials

min 9516ms · median 10172ms · max 10829ms · rows 4,4

single-id count

Command

SELECT COUNT(*) AS n FROM gmail.message_attachments WHERE attachment_id = 'ANGjdJ-Kl_YrYF92wRPJ3FhWiiaHB8EaA_YrKQUCBGmnKfH0l3eECpEh0dBGg3B6f0QOR87OW1M_Z8LvvfZHQt4ZNZK3yLO4Osjwge0Kj-0Ccmptb7o-CREJGww-bBUPv_XQtKIh0dZITVVx28FLQoSXKt99xSwrgTcC99BRPlYXXg6reMflEsTbA9_B2QLPi4khxeslOEsbvwQQPqXWdo6b4A1eY7OzaeqJkIhL9mWXxT-Y206tWkm07FcoREejP2-8AKCXiEyVwIKjaHePhN7jmjpH2azZC9QU4zvRjmi16sKaEq8Q49E4vVZCSAHxJnMMkeFaNFviifnp0nWwb5QXdKDXpYWkU-APWa50yemPxzMfyoeTkW08EaXtkibjNINVyIbR_lpb6Q4419Vy' AND message_id = '1a05c918ce469e58'

Trials + output

trial 1·10829ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+---+

trial 2·9516ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+---+

json-extract2 trials

min 7141ms · median 7409ms · max 7678ms · rows 2,2

typed JSON

Command

SELECT message_id, attachment_id, size, json_as_text(raw, 'attachmentId') AS raw_id FROM gmail.message_attachments WHERE attachment_id = 'ANGjdJ-Kl_YrYF92wRPJ3FhWiiaHB8EaA_YrKQUCBGmnKfH0l3eECpEh0dBGg3B6f0QOR87OW1M_Z8LvvfZHQt4ZNZK3yLO4Osjwge0Kj-0Ccmptb7o-CREJGww-bBUPv_XQtKIh0dZITVVx28FLQoSXKt99xSwrgTcC99BRPlYXXg6reMflEsTbA9_B2QLPi4khxeslOEsbvwQQPqXWdo6b4A1eY7OzaeqJkIhL9mWXxT-Y206tWkm07FcoREejP2-8AKCXiEyVwIKjaHePhN7jmjpH2azZC9QU4zvRjmi16sKaEq8Q49E4vVZCSAHxJnMMkeFaNFviifnp0nWwb5QXdKDXpYWkU-APWa50yemPxzMfyoeTkW08EaXtkibjNINVyIbR_lpb6Q4419Vy' AND message_id = '1a05c918ce469e58' LIMIT 1

Trials + output

trial 1·7678ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

trial 2·7141ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

edge2 trials

min 7090ms · median 7256ms · max 7422ms · rows 2,2

edge: capped LIMIT

Command

SELECT message_id, attachment_id, size FROM gmail.message_attachments WHERE attachment_id = 'ANGjdJ-Kl_YrYF92wRPJ3FhWiiaHB8EaA_YrKQUCBGmnKfH0l3eECpEh0dBGg3B6f0QOR87OW1M_Z8LvvfZHQt4ZNZK3yLO4Osjwge0Kj-0Ccmptb7o-CREJGww-bBUPv_XQtKIh0dZITVVx28FLQoSXKt99xSwrgTcC99BRPlYXXg6reMflEsTbA9_B2QLPi4khxeslOEsbvwQQPqXWdo6b4A1eY7OzaeqJkIhL9mWXxT-Y206tWkm07FcoREejP2-8AKCXiEyVwIKjaHePhN7jmjpH2azZC9QU4zvRjmi16sKaEq8Q49E4vVZCSAHxJnMMkeFaNFviifnp0nWwb5QXdKDXpYWkU-APWa50yemPxzMfyoeTkW08EaXtkibjNINVyIbR_lpb6Q4419Vy' AND message_id = '1a05c918ce469e58' LIMIT 25

Trials + output

trial 1·7090ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

trial 2·7422ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

16 rows stored · 40 returned · page 1/1


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

Column profile

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

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

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
real-id-shape	t1	9200ms	2	ok	+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+
real-id-shape	t2	10108ms	2	ok	+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+
aggregate	t1	10829ms	4	ok	+---+
aggregate	t2	9516ms	4	ok	+---+
json-extract	t1	7678ms	2	ok	+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+--------+
json-extract	t2	7141ms	2	ok	+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+--------+
edge	t1	7090ms	2	ok	+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+
edge	t2	7422ms	2	ok	+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires `message_id` and `attachment_id`. Attachment IDs are exposed

Columns coral returned (1)

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T17:06:32Z

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

first_run_at: 2026-09-01T14:10:16Z

last_retried_at: 2026-09-01T17:06:32Z

retry_count: 2

View version history →