BigQuery

Masthead’s BigQuery integration provides comprehensive data observability, cost optimization, and governance for your core data warehouse. Monitor data pipelines, track costs, and ensure data quality across your BigQuery environment.

Connect via OAuth

Open Integrations page.

Click Connect in BigQuery section.

Click Add project, choose Deploy with OAuth and enter the project ID to configure connection.

Connect via Terraform

module "masthead-agent" {
  source  = "masthead-data/masthead-agent/google"

  project_id = "YOUR_PROJECT_ID"

  # Enable modules for the used services
  enable_modules = {
    bigquery      = true
    dataform      = true
    dataplex      = true
    analytics_hub = true
  }
}

More details about the module on Terraform Registry.

After applying the Terraform configuration, go to Deployment page, click Verify custom deployment and enter the project ID to complete the integration.

Projects

The BigQuery integration page groups connected projects into folders that match your Google Cloud resource hierarchy. Projects outside any folder appear under <No folder>.

Permissions

Each project shows the permissions Masthead tracks. An inactive permission is highlighted, and its tooltip explains why. A folder shows a permission only when at least one project inside it lacks access.

Status and dates

Each project has one of these statuses:

Missing Permissions: The project lacks at least one tracked permission.
Connected: Masthead has all the permissions it needs.
Disconnected: The project was connected before and isn’t now. It doesn’t count toward the connected projects total and doesn’t trigger Reconnect.

Masthead didn’t record the date a project was added before October 22, 2026, so the date for a project you connected earlier might not be accurate.

Select projects

Selecting a folder selects every project inside it. Your selection applies to the dashboard only after you confirm it, so canceling leaves the current filter unchanged.

What’s next

After successful integration, Masthead provides comprehensive insights within approx. 20 minutes:

Data observability - Monitor table freshness, pipeline health, and data quality
Cost optimization - Analyze compute and storage costs with actionable recommendations
Column-level lineage - Visualize data flow and dependencies across your warehouse
Performance insights - Identify optimization opportunities for queries and resources

Explore your Observability Dashboard to get started.