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 the where 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,
  timezone
from
  googleworkspace_calendar
where
  id = 'user@domain.com';

select
  summary,
  id,
  timezone
from
  googleworkspace_calendar
where
  id = 'user@domain.com';

Schema for googleworkspace_calendar

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
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.
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