Google BigQuery

https://cloud.google.com/bigquery/

Google BigQuery is a serverless, highly scalable data warehouse.

Google BigQuery Python SDK is not compatible with gevent. Use a worker type other than gevent when deploying with gunicorn.

Installation

Required packages: sqlalchemy-bigquery

echo "sqlalchemy-bigquery" >> ./docker/requirements-local.txt

Connection String

bigquery://{project_id}

Authentication Methods

Service Account JSON

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 83/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Troubleshooting

Common error messages you may encounter when connecting to or querying Google BigQuery, along with their causes and solutions.

Permissions1 error

Query4 errors

Notes

Create a Service Account via GCP console with access to BigQuery datasets. For CSV/Excel uploads, also install pandas_gbq.

Resources

Official Documentation

Help improve this documentation by editing the engine spec:

Edit superset.db_engine_specs.bigquery.py