Google BigQuery
Connect DataDrop to your BigQuery data warehouse.
Prerequisites
- A Google Cloud project with BigQuery enabled
- A service account with BigQuery Data Viewer and BigQuery Job User roles
- The service account key JSON file
- An S3 bucket and IAM role for file delivery
Connection Parameters
| Parameter | Required | Description |
|---|---|---|
| project_id | Required | Google Cloud project ID.e.g. my-gcp-project |
| dataset | Required | BigQuery dataset name.e.g. analytics |
| credentials_json | Optional | Full service account key JSON. Either this or a Secret ARN is required. |
| credentials_secret | Optional | AWS Secrets Manager ARN storing the service account JSON. |
| location | Optional | BigQuery dataset location.e.g. US |
Service Account Setup
To create a service account for DataDrop:
- Go to IAM & Admin → Service Accounts in Google Cloud Console
- Click “Create Service Account”
- Grant it the BigQuery Data Viewer and BigQuery Job User roles
- Create a JSON key and download it
- Paste the full JSON into the credentials field, or store it in AWS Secrets Manager
Location
The location field should match your BigQuery dataset location (e.g. US, EU, us-central1). Queries will run in this location. If omitted, BigQuery will use the dataset's default location.