---
id: pybigquery
version: "0.10.2"
license: unclear
license_treatment: permissive
maintenance: abandoned
---

# pybigquery — OBSOLETE SQLAlchemy dialect for BigQuery

License: permissive · Maintenance: abandoned · Downloads: 199.2K/mo

## What it is and what it does

pybigquery is a SQLAlchemy dialect that bridges SQLAlchemy to Google BigQuery, allowing you to write SQL queries and ORM code against BigQuery datasets as if they were local databases. It wraps the google-cloud-bigquery client and integrates with SQLAlchemy's engine and connection abstractions, supporting table reflection, parameterized queries, and BigQuery-specific options like dataset location, batch size, and query job configuration.

The package is now obsolete and abandoned. Its documentation explicitly directs users to sqlalchemy-bigquery instead, and the repository has been archived with no commits since 2021. While it carries no known vulnerabilities and remains installable, it will not receive bug fixes, security patches, or compatibility updates for newer Python or BigQuery API versions.

Use it for:

- Migrating legacy SQLAlchemy applications that previously used pybigquery to sqlalchemy-bigquery for continued support
- Querying BigQuery tables through SQLAlchemy ORM in applications locked to older codebases that cannot migrate
- Prototyping BigQuery integration in environments where only historical package versions are available
- Dry-running BigQuery queries via the ApiClient to estimate query cost before execution

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

SQLAlchemy dialect for BigQuery that enables SQL queries against BigQuery datasets using SQLAlchemy's ORM and expression language.

No. The package is explicitly marked obsolete and abandoned; its own documentation directs users to sqlalchemy-bigquery instead. Do not install for new projects. For existing codebases using pybigquery, plan a migration to sqlalchemy-bigquery to ensure ongoing compatibility and security support.

## Install

pip install pybigquery
uv add pybigquery
poetry add pybigquery

## Installing pybigquery

Before you install: Low install friction with standard dependencies, but the package is abandoned as of 2021-08-19 and explicitly marked obsolete in its own documentation. The repository is archived; no maintenance or security updates are forthcoming.

License in practice: Licensed under MIT (permissive), which imposes no restrictions on use or redistribution.

Quickstart:

pip install pybigquery

from sqlalchemy import create_engine, Table, MetaData, select, func
engine = create_engine('bigquery://project')
table = Table('dataset.table', MetaData(bind=engine), autoload=True)
print(select([func.count('*')], from_obj=table).scalar())

Requires Python >= 3.6, < 3.10; Google Cloud authentication credentials must be configured (service account JSON or environment-based); BigQuery Storage API must be enabled in the GCP project.

Verify before relying:

- Whether sqlalchemy-bigquery (the recommended replacement) is a drop-in substitute or requires code changes
- Current compatibility with modern BigQuery API versions and recent SQLAlchemy releases
- Whether the package still works with Python versions beyond 3.9 despite the <3.10 constraint

## Package facts

- License: not declared (permissive)
- Python support: capped_below_current
- Install friction: low
- Maintenance: abandoned
- Downloads: 199.2K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy bigquery dialect, bigquery sql orm, sqlalchemy bigquery connector, bigquery database adapter, sqlalchemy bigquery integration, abandoned, bigquery, sqlalchemy-dialect

[View on SkillFed](https://skillfed.io/packages/pybigquery) · [View on PyPI](https://pypi.org/project/pybigquery/)