Back to Connectors

BigQuery Connector

Connect to Google BigQuery to sync datasets, tables, and views.

Prerequisites

  • Google Cloud project with BigQuery API enabled
  • Service account with BigQuery Metadata Viewer role

Setup

  1. Create a service account in Google Cloud Console
  2. Grant BigQuery Metadata Viewer and BigQuery Job User roles
  3. Download the JSON key file
  4. In Zenithdata, upload the service account key

Required Roles

roles/bigquery.metadataViewer
roles/bigquery.jobUser  # For lineage parsing

Sync Options

  • Metadata: Datasets, tables, views, columns
  • Lineage: INFORMATION_SCHEMA.JOBS parsing
  • Labels: GCP labels as tags