Integration

Connect BigQuery to sync product usage into Sonora

Connect BigQuery to sync product usage into Sonora

Overview

If your product usage lives in BigQuery, it belongs on your customer records. Now you can connect a BigQuery table or view directly to Sonora and sync usage onto every account — no exports, no scripts, no one-off pulls from data eng.

What syncs

Point Sonora at one table or view keyed by a customer identifier, and every numeric column becomes a usage metric on the matching account:

  • Product usage metrics: feature adoption, logins, seats, API calls — whatever your product team already tracks in the warehouse
  • Fixed columns: Sonora reads account ID, a date, and an optional product column, then imports every other numeric column as a metric
  • Automatic matching: rows resolve to the right customer by their external ID from your configured CRM source (Salesforce or HubSpot)
  • CRM stays the source of accounts: BigQuery syncs usage onto existing customers, so keep Salesforce or HubSpot connected as your list of accounts

Everything lands on the same unified customer record as your CRM and support data, so health scores, Canvas, and Ask Kit can reason across usage and lifecycle in one place.

Grant access, don’t share keys

You never hand Sonora a credential. Instead, you grant our service account read access — the BigQuery Data Viewer role — scoped to only the dataset you approve, from the Cloud Console, the gcloud CLI, or Terraform. The connection is read-only, and Sonora never writes back to your warehouse.

Map your columns

Set it up once from Settings: point Sonora at the project, location, dataset, and table, then map the customer ID column, the date column, an optional product column, and the usage metrics you want. The first sync pulls history; after that, syncs run on the schedule you set and pull only new rows.

Get started

Go to Settings → Data Sources → BigQuery → Configure. The full walkthrough, including the three ways to grant read access, is in the BigQuery docs.