`google_calendar.events`

pass

Events on a Google Calendar

Omit `calendar_id` to query the primary calendar, or pass

no filters captured 2026-09-01 12:59:34Zmedian 7223 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	6985 ms	7223 ms	7461 ms	[2, 2]
order-time	2	7137 ms	7143 ms	7149 ms	[2, 2]
filter-type	2	7044 ms	7156 ms	7269 ms	[2, 2]
filter-status	2	7182 ms	7369 ms	7556 ms	[2, 2]
group-by	2	7204 ms	7298 ms	7393 ms	[2, 2]
json-extract	2	7116 ms	7122 ms	7129 ms	[2, 2]
aggregate	2	7151 ms	7391 ms	7631 ms	[2, 2]
edge	2	7128 ms	7135 ms	7142 ms	[2, 2]

Latency per trial

minimalmedian 7223ms

scale: 0–7461 ms

order-timemedian 7143ms

scale: 0–7149 ms

filter-typemedian 7156ms

scale: 0–7269 ms

filter-statusmedian 7369ms

scale: 0–7556 ms

group-bymedian 7298ms

scale: 0–7393 ms

json-extractmedian 7122ms

scale: 0–7129 ms

aggregatemedian 7391ms

scale: 0–7631 ms

edgemedian 7135ms

scale: 0–7142 ms

Probe variants — every command + output

minimal2 trials

min 6985ms · median 7223ms · max 7461ms · rows 2,2

smallest query

Command

SELECT id, calendar_id, summary, event_type, status FROM google_calendar.events LIMIT 1

Trials + output

trial 1·6985ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7461ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

order-time2 trials

min 7137ms · median 7143ms · max 7149ms · rows 2,2

most recent events

Command

SELECT id, summary, start_date_time, end_date_time, event_type FROM google_calendar.events ORDER BY start_date_time DESC LIMIT 25

Trials + output

trial 1·7149ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7137ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

filter-type2 trials

min 7044ms · median 7156ms · max 7269ms · rows 2,2

birthday events

Command

SELECT id, summary, start_date_time, status FROM google_calendar.events WHERE event_type = 'birthday' LIMIT 25

Trials + output

trial 1·7044ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7269ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

filter-status2 trials

min 7182ms · median 7369ms · max 7556ms · rows 2,2

confirmed events

Command

SELECT id, summary, event_type FROM google_calendar.events WHERE status = 'confirmed' LIMIT 25

Trials + output

trial 1·7182ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7556ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

group-by2 trials

min 7204ms · median 7298ms · max 7393ms · rows 2,2

events by type

Command

SELECT event_type, COUNT(*) AS n FROM google_calendar.events GROUP BY event_type ORDER BY n DESC

Trials + output

trial 1·7393ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7204ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

json-extract2 trials

min 7116ms · median 7122ms · max 7129ms · rows 2,2

typed JSON fields

Command

SELECT id, summary, json_as_text(attendees, '0.email') AS first_attendee, json_as_text(reminders, 'useDefault') AS reminders_default FROM google_calendar.events WHERE event_type = 'default' LIMIT 5

Trials + output

trial 1·7116ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7129ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

aggregate2 trials

min 7151ms · median 7391ms · max 7631ms · rows 2,2

events by type + status

Command

SELECT event_type, status, COUNT(*) AS n FROM google_calendar.events GROUP BY event_type, status ORDER BY n DESC

Trials + output

trial 1·7151ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7631ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

edge2 trials

min 7128ms · median 7135ms · max 7142ms · rows 2,2

edge: larger limit

Command

SELECT id, summary, event_type, start_date_time FROM google_calendar.events LIMIT 200

Trials + output

trial 1·7128ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7142ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

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

32 rows stored · 64 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	28	`"+-----------------------------------------------------------"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	6985ms	2	ok	+---------------------------------------------------------------------------------------------------+-------------+------------------------------------------------------+------------+-----------+
minimal	t2	7461ms	2	ok	+---------------------------------------------------------------------------------------------------+-------------+------------------------------------------------------+------------+-----------+
order-time	t1	7149ms	2	ok	+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------+----------------------+----------------------+------------+
order-time	t2	7137ms	2	ok	+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------+----------------------+----------------------+------------+
filter-type	t1	7044ms	2	ok	+----------------------------+-----------------+-----------------+-----------+
filter-type	t2	7269ms	2	ok	+----------------------------+-----------------+-----------------+-----------+
filter-status	t1	7182ms	2	ok	+-------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------+------------+
filter-status	t2	7556ms	2	ok	+-------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------+------------+
group-by	t1	7393ms	2	ok	+------------+----+
group-by	t2	7204ms	2	ok	+------------+----+
json-extract	t1	7116ms	2	ok	+---------------------------------------------------------------------------------------------------+-------------------------------------------------------------------+----------------+-------------------+
json-extract	t2	7129ms	2	ok	+---------------------------------------------------------------------------------------------------+-------------------------------------------------------------------+----------------+-------------------+
aggregate	t1	7151ms	2	ok	+------------+-----------+----+
aggregate	t2	7631ms	2	ok	+------------+-----------+----+
edge	t1	7128ms	2	ok	+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------+------------+----------------------+
edge	t2	7142ms	2	ok	+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------+------------+----------------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Omit `calendar_id` to query the primary calendar, or pass

Columns coral returned (1)

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

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T12:59:34Z

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

first_run_at: 2026-09-01T12:59:34Z

last_retried_at: 2026-09-01T12:59:34Z

retry_count: 1

View version history →