BigQuery

Category: SQL Status: base

Connects to Google BigQuery — a serverless cloud data warehouse. Supports running SQL queries, browsing datasets/tables, and exporting results.

Connection Settings

Field	Default	Description
project_id	(empty)	GCP project ID
credentials_name	(empty)	Name of the service account JSON credentials file

Authentication

Google Cloud service account JSON key file. The service account needs the BigQuery Data Viewer + BigQuery Job User roles (or BigQuery Admin for write access).

To set up credentials: 1. Open https://console.cloud.google.com/iam-admin/serviceaccounts 2. Create a service account and assign BigQuery roles 3. Create and download a JSON key 4. Upload the key file to dbwebtool and set credentials_name to the filename

Supported Actions

• execute — run SQL queries
• download — export query results
• delete — drop tables
• select_schemas — browse datasets and tables
• transfer_table — copy table to another connector

Required Setup

Requires the google-cloud-bigquery Python package:

pip install google-cloud-bigquery

Enable the BigQuery API for your project: https://console.cloud.google.com/apis/library/bigquery.googleapis.com

External Links

• https://cloud.google.com/bigquery/docs/
• https://console.cloud.google.com/bigquery