CloudQuery Google Workspace Source Plugin

View this plugin on CloudQuery Hub

A Google Workspace source plugin for CloudQuery that loads data from Google Workspace to any database, data warehouse or data lake supported by CloudQuery, such as PostgreSQL, BigQuery, Athena, and many more.

Links

• CloudQuery Quickstart Guide
• Supported Tables

Configuration

The following source configuration file will sync to a PostgreSQL database. See the CloudQuery Quickstart for more information on how to configure the source and destination.

If token_file is set, after you successfully authenticate via OAuth, your access token will be written to the token_file. The token_file will be used on subsequent syncs.

How to find your Google Workspace Customer ID: https://support.google.com/a/answer/10070793?hl=en

You can get your own OAuth credentials using this guide. When creating your OAuth Client ID, you should select "Desktop app". You also need to enable the Admin SDK API for your Cloud Project.

kind: source
spec:
  name: "googleworkspace"
  path: "jsifuentes/googleworkspace"
  registry: "cloudquery"
  version: "v1.1.0"
  destinations:
    - "postgresql"
  spec:
    customer_id: your Google Workspace Customer ID
    oauth:
      # token_file: ./token.json
      client_id: your Google Cloud Project OAuth Client ID
      client_secret: your Google Cloud Project OAuth Client Secret

Development

Run tests

make test

Run linter

make lint

Generate docs

make gen-docs

Release a new version

1. Run git tag v1.0.0 to create a new tag for the release (replace v1.0.0 with the new version number)
2. Run git push origin v1.0.0 to push the tag to GitHub

Once the tag is pushed, a new GitHub Actions workflow will be triggered to build the release binaries and create the new release on GitHub. To customize the release notes, see the Go releaser changelog configuration docs.