BigQuery

Overview

Allow Fours 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 Fours to Google BigQuery, you can build customized automation workflows for usage metering, financial reports, or notifications.

Org-Level vs User-Level

Org-Level: Uses a GCP service account for organization-wide BigQuery access. Best for company-wide data analytics.

User-Level: Not applicable — BigQuery is an org-level integration only.

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 Fours.

Fours AI Tools

When BigQuery is connected, the Fours AI agent can explore and query your warehouse through Fours’ built-in tools (4 actions).

Org-level only: BigQuery tools use the org-level service account credentials.

run-query passes whatever SQL it is given to BigQuery, statements that change data included, so an agent gets it only with Full access to BigQuery. With Read-only or Edit access the agent can still list datasets and tables and read their schemas, but it can’t run a query. See Agent access levels.

Edit Integration

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

Delete Integration

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