`google_calendar.calendars`

pass

Calendars on the authenticated user's calendar list

Start here to discover calendar IDs. Use `events_calendar_id` values

no filters captured 2026-09-01 12:56:14Zmedian 7105 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	7090 ms	7105 ms	7121 ms	[2, 2]
list	2	7163 ms	7199 ms	7236 ms	[2, 2]
primary	2	7057 ms	7112 ms	7167 ms	[2, 2]
group-by	2	7080 ms	7246 ms	7412 ms	[2, 2]
json-extract	2	7016 ms	7044 ms	7073 ms	[2, 2]
aggregate	2	7111 ms	7244 ms	7378 ms	[2, 2]
edge	2	7016 ms	7031 ms	7047 ms	[2, 2]

Latency per trial

minimalmedian 7105ms

scale: 0–7121 ms

listmedian 7199ms

scale: 0–7236 ms

primarymedian 7112ms

scale: 0–7167 ms

group-bymedian 7246ms

scale: 0–7412 ms

json-extractmedian 7044ms

scale: 0–7073 ms

aggregatemedian 7244ms

scale: 0–7378 ms

edgemedian 7031ms

scale: 0–7047 ms

Probe variants — every command + output

minimal2 trials

min 7090ms · median 7105ms · max 7121ms · rows 2,2

smallest query

Command

SELECT id, summary, time_zone, primary FROM google_calendar.calendars LIMIT 1

Trials + output

trial 1·7090ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7121ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

list2 trials

min 7163ms · median 7199ms · max 7236ms · rows 2,2

all calendars

Command

SELECT id, summary, time_zone, primary, selected, hidden FROM google_calendar.calendars ORDER BY summary ASC LIMIT 25

Trials + output

trial 1·7236ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7163ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

primary2 trials

min 7057ms · median 7112ms · max 7167ms · rows 2,2

primary calendars

Command

SELECT id, summary, time_zone, access_role FROM google_calendar.calendars WHERE primary = true LIMIT 25

Trials + output

trial 1·7057ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7167ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

group-by2 trials

min 7080ms · median 7246ms · max 7412ms · rows 2,2

calendars by access role

Command

SELECT access_role, COUNT(*) AS n FROM google_calendar.calendars GROUP BY access_role ORDER BY n DESC

Trials + output

trial 1·7412ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7080ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

json-extract2 trials

min 7016ms · median 7044ms · max 7073ms · rows 2,2

typed JSON alongside calendar row

Command

SELECT id, summary, json_as_text(notification_settings, 'notifications') AS notifications FROM google_calendar.calendars LIMIT 5

Trials + output

trial 1·7073ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7016ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

aggregate2 trials

min 7111ms · median 7244ms · max 7378ms · rows 2,2

calendar totals

Command

SELECT COUNT(*) AS n, COUNT(DISTINCT time_zone) AS zones FROM google_calendar.calendars

Trials + output

trial 1·7378ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7111ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

edge2 trials

min 7016ms · median 7031ms · max 7047ms · rows 2,2

edge: larger limit

Command

SELECT id, summary, time_zone FROM google_calendar.calendars LIMIT 200

Trials + output

trial 1·7047ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7016ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

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

28 rows stored · 56 returned · page 1/2


-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	—	—	—	+-------------+---+	—	—	—
0	13	—	—	—	+-------------+---+	—	—	—
1	14	—	—	—	+-------------+---+	—	—	—
2	15	—	—	—	+-------------+---+	—	—	—
-1	16	—	—	—	—	+--------------------------------------------------------+---------------------…	—	—
0	17	—	—	—	—	+--------------------------------------------------------+---------------------…	—	—
1	18	—	—	—	—	+--------------------------------------------------------+---------------------…	—	—
2	19	—	—	—	—	+--------------------------------------------------------+---------------------…	—	—
-1	20	—	—	—	—	—	+---+-------+	—
0	21	—	—	—	—	—	+---+-------+	—
1	22	—	—	—	—	—	+---+-------+	—
2	23	—	—	—	—	—	+---+-------+	—
-1	24	—	—	—	—	—	—	+----------------------------------------------------------+-------------------…

Column profile

1 columns actually returned by coral. Catalog claims no required filters. Click a column to drill in.

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

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	7090ms	2	ok	+--------------------------------------------------------+---------------------------+--------------+---------+
minimal	t2	7121ms	2	ok	+--------------------------------------------------------+---------------------------+--------------+---------+
list	t1	7236ms	2	ok	+----------------------------------------------------------+---------------------------+--------------+---------+----------+--------+
list	t2	7163ms	2	ok	+----------------------------------------------------------+---------------------------+--------------+---------+----------+--------+
primary	t1	7057ms	2	ok	+----------------------+----------------------+--------------+-------------+
primary	t2	7167ms	2	ok	+----------------------+----------------------+--------------+-------------+
group-by	t1	7412ms	2	ok	+-------------+---+
group-by	t2	7080ms	2	ok	+-------------+---+
json-extract	t1	7073ms	2	ok	+--------------------------------------------------------+---------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
json-extract	t2	7016ms	2	ok	+--------------------------------------------------------+---------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
aggregate	t1	7378ms	2	ok	+---+-------+
aggregate	t2	7111ms	2	ok	+---+-------+
edge	t1	7047ms	2	ok	+----------------------------------------------------------+---------------------------+--------------+
edge	t2	7016ms	2	ok	+----------------------------------------------------------+---------------------------+--------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Start here to discover calendar IDs. Use `events_calendar_id` values

Columns coral returned (1)

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

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T12:56:14Z

JSON record: reports/google_calendar/tables/calendars.json

first_run_at: 2026-09-01T12:56:14Z

last_retried_at: 2026-09-01T12:56:14Z

retry_count: 1

View version history →