Suger

BigQuery

Overview

Allow Suger to query and manage data in Google BigQuery.

Google BigQuery is a fully-managed, serverless, highly-scalable cloud data warehouse and analytics platform offered by Google Cloud Platform (GCP). It is designed to handle massive datasets and enable fast SQL queries using a pay-as-you-go pricing model.

By connecting Suger to Google BigQuery, you can build customized automation workflows for usage metering, financial reports, or notifications.

Org-Level vs User-Level

When to use Org-Level: Use org-level integration when you want organization-wide BigQuery access using a service account. Best for company-wide data analytics.

When to use User-Level: Use user-level integration when each user needs to access their personal BigQuery datasets. Each user authenticates with their own credentials.

Create Integration (Org-Level)

Prerequisites

  • GCP project with BigQuery API enabled
  • Service account with BigQuery Admin role or appropriate dataset permissions

Authenticate by Service Account

  1. Create a service account in your target GCP project for BigQuery service.
  2. Grant appropriate BigQuery permissions to the service account. Some suggested options include:
    • BigQuery Admin
    • BigQuery User
    • BigQuery Data Viewer
  3. Create a service account key and download the associated JSON file.
  4. Enter the service account email and upload the JSON key in Suger.

Create User Integration

Use user-level integration for personal BigQuery access.

  1. Click Connect Now button in the User Integrations section
  2. You will be redirected to Google to authorize
  3. Grant access to your BigQuery datasets
  4. Return to Suger to confirm connection

Edit Integration

Editing is not supported. To change configuration, delete and recreate.

Delete Integration

Deleting removes the integration and revokes access. No recovery window.