Table: googleworkspace_calendar - Query Google Workspace Calendars using SQL
Google Workspace Calendar is a time-management and scheduling service developed by Google. It enables users to create and edit events, manage multiple calendars, and share calendars with others. Google Workspace Calendar is fully integrated with other Google services, providing seamless scheduling and collaboration capabilities.
Table Usage Guide
The googleworkspace_calendar
table provides insights into calendars within Google Workspace. As a system administrator or IT professional, explore calendar-specific details through this table, including the summary, description, location, and timezone. Utilize it to manage and monitor the usage of calendars, such as those shared with many users, the timezone settings of each calendar, and the description and summary details.
Important Notes
- You must specify the
id
in thewhere
or join clause (where id=
,join googleworkspace_calendar c on c.id=
) to query this table.
Examples
Basic info
Explore the basic details of a specific user's Google Workspace Calendar. This can help in understanding the user's time zone and other relevant information to enhance scheduling and coordination.
select summary, id, timezonefrom googleworkspace_calendarwhere id = 'user@domain.com';
select summary, id, timezonefrom googleworkspace_calendarwhere id = 'user@domain.com';
Schema for googleworkspace_calendar
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
conference_properties | jsonb | Describes the conferencing properties for this calendar. | |
description | text | Description of the calendar. | |
etag | text | ETag of the resource. | |
id | text | = | Identifier of the calendar. |
location | text | Geographic location of the calendar as free-form text. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
summary | text | Title of the calendar. | |
timezone | text | The time zone of the calendar. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- googleworkspace
You can pass the configuration to the command with the --config
argument:
steampipe_export_googleworkspace --config '<your_config>' googleworkspace_calendar