2 min read

Google BigQuery Integration

Overview

The BigQuery integration connects Vantage to Google BigQuery, Google's fully managed, serverless data warehouse. Run SQL queries against massive datasets, insert rows into tables, and translate data between formats — all directly from your Vantage workflows.

API Documentation: BigQuery API Reference

Prerequisites

Requirement	Details
Google Cloud Account	A Google Cloud project with BigQuery API enabled
Service Account	A GCP service account with BigQuery permissions
Credentials	Service account JSON key file
Auth Type	Service Account / OAuth

Available Actions

Action	Description
Run Query	Execute SQL queries against BigQuery datasets and retrieve results
Insert Rows	Insert one or more rows into a BigQuery table
Translate Data	Transform and translate data between formats for BigQuery compatibility

Configuration

Service Account Credentials

Setting: GCP service account credentials
Type: JSON key (required)
Description: A Google Cloud service account key with bigquery.dataEditor and bigquery.jobUser roles. Upload the JSON key file when connecting the integration.

Project ID

Setting: projectId
Type: String (required)
Description: Your Google Cloud project ID where the BigQuery datasets reside.

Dataset

Setting: dataset
Type: String (required)
Description: The default BigQuery dataset to query against.

Use Cases & Examples

Large-Scale Data Analysis

Run complex SQL queries against terabyte-scale datasets for business intelligence, reporting, and trend analysis without managing infrastructure.

ETL Pipelines

Build workflows that extract data from external sources, transform it within Vantage, and load it into BigQuery tables for centralized analytics.

Cross-Platform Reporting

Combine data from multiple Vantage integrations (Stripe transactions, Shopify orders, CRM records) and insert aggregated results into BigQuery for unified reporting.

Example: Running a Query

A workflow node configured to run a BigQuery SQL query:

json

{
  "projectId": "my-project-123",
  "dataset": "analytics",
  "query": "SELECT date, SUM(revenue) as total_revenue FROM sales GROUP BY date ORDER BY date DESC LIMIT 30"
}

BigQuery Run Query — Execute SQL queries
BigQuery Insert Rows — Insert rows into tables
BigQuery Translate Data — Transform data for BigQuery