pybigquery
OBSOLETE SQLAlchemy dialect for BigQuery
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- 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.
- 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 · maintenance · safety
permissive license (permissive) — Licensed under MIT (permissive), which imposes no restrictions on use or redistribution.
last release 2021-08-19 (1821 days) · last repo commit 2026-03-16 · 490 stars · archived
0 known vulnerabilities (OSV.dev, 2026-08-14) · 199,235 downloads/mo, #9,712 on PyPI
Alternatives
Verify before relying
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())- 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
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 on it.
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
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.
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.
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())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 | permissive license permissive |
| Python support | Capped below the current Python release >=3.6, <3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 5 packagesgoogle-cloud-bigquerygoogle-api-coregoogle-authsqlalchemyfuture |
| Maintenance | Abandoned 1,821 days since the last release |
| Last repo commit | repository archived |
| First released | |
| Downloads | 199,235 / month, #9,712 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 7 - InactiveIntended Audience :: DevelopersLicense :: OSI Approved :: MIT LicenseOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.6Programming Language :: Python :: 3.7Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Topic :: Database :: Front-Ends |
Evidence: pybigquery-0.10.2-py2.py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “sqlalchemy bigquery dialect”
- pybigquerySQLAlchemy dialect for BigQuery that enables SQL queries against…
- sqlalchemy-bigquerySQLAlchemy dialect that enables you to use BigQuery as a database…
- sqlalchemy-pgspiderProvides a SQLAlchemy dialect that enables connections to PGSpider…
Give your agent the search over MCP, or paste the wish link into any chat.
More Front-Ends packages
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (ORM) that provides both a high-level ORM layer for declarative object persistence and a Core SQL construction system for direct database abstraction and query building.
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Alembic generates and manages database schema migrations for SQLAlchemy applications, handling version control of database structure changes with support for upgrades, downgrades, and auto-generation from model changes.
Install it if you use SQLAlchemy and need to version-control schema changes; skip it only if you manage migrations manually or use a different ORM entirely.
A Python client library for connecting to and querying Weaviate, a vector database that enables semantic search and AI-powered data retrieval.
A Python client library that connects to Databricks clusters and SQL warehouses using a Thrift-based protocol, conforming to the Python DB API 2.0 specification and supporting Arrow-based data exchange.
Install it if you need to query Databricks clusters or SQL warehouses from Python.
Psycopg 3 is a PostgreSQL database adapter for Python that enables applications to connect to, query, and manage PostgreSQL databases using Python code.
Install it if you need to connect Python to PostgreSQL.
See also db-dtypes · sqlalchemy-bigquery · sqlalchemy-solr · sqlalchemy-trino · bigquery-magics · sqlalchemy-hana · sqlalchemy-databricks · databricks-sqlalchemy · sqlalchemy-pgspider · ibm-db-sa