BigQuery Connector

1Connect

2Select Tables

3Process

4Download

<\!-- Step 1 -->

Connect to Google BigQuery

Provide your GCP project details and upload a service account key to connect.

GCP Project ID

Found in the GCP Console → Project selector

Dataset ID

The BigQuery dataset containing your tables

Location / Region

Service Account Key (JSON)

📄

Click to upload or drag & drop

service-account-key.json

Or paste JSON directly below

Setup guide

Open GCP Console → IAM & Admin → Service Accounts

Create a new service account with role: BigQuery Data Viewer + BigQuery Job User

Create a key → JSON format → download the file

Upload the downloaded JSON file here — Adam never stores keys beyond your session

If using VPC Service Controls, add Adam's service account to the perimeter allowlist

<\!-- Step 2 -->

Select tables to process

Connected to my-project / production_analytics — 5 tables found

Select BigQuery tables to anonymise.

user_events12.4M rows · 11 cols · partitionedTABLE customer_profiles284,100 rows · 14 colsTABLE transaction_summary1.8M rows · 8 cols · clusteredTABLE revenue_by_cohort42,000 rows · 6 colsVIEW ml_feature_store5.2M rows · 22 colsTABLE

Schema preview — customer_profiles

customer_profiles · NATIVE TABLE · EU

Field	Type	Mode	Description
customer_id	STRING	REQUIRED	Primary identifier
email_address	STRING	NULLABLE	PII — contact email
full_name	STRING	NULLABLE	PII — display name
age_band	STRING	NULLABLE	Age bracket e.g. 25-34
acquisition_channel	STRING	NULLABLE
created_at	TIMESTAMP	REQUIRED	Account creation time

<\!-- Step 3 -->

Processing tables

Streaming data from BigQuery, running PII detection, and applying anonymisation.

[10:44:01] Authenticated to GCP project: my-analytics-project

[10:44:01] BigQuery API: europe-west2 · dataset: production_analytics

[10:44:02] Starting processing run for 2 tables

<\!-- Step 4 -->

Download anonymised data

Processing complete. Your anonymised BigQuery exports are ready.

user_events_anon

12.4M rows · Parquet · 284 MB

customer_profiles_anon

284,100 rows · CSV · 18.7 MB

Provenance Report

PII detection + anonymisation audit trail

Explore Data →