pybigquery

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 on this page — 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

pybigquery on PyPI

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

Evidence: pybigquery-0.10.2-py2.py3-none-any.whl

Keywords: bigquery, sqlalchemy

Tags

More Front-Ends packages