google-cloud-bigquery
Google BigQuery API client library
Decision gist · record as of 2026-08-14
Yes, with caution. The package is widely used (254119339 monthly downloads, top 1000 on PyPI), has no known vulnerabilities, and low install friction. However, the archived repository and abandoned maintenance status mean you should verify that Google continues to ship security and compatibility patches through its internal release process before adopting it for new production systems.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python >= 3.10 and Google Cloud authentication credentials configured (via GOOGLE_APPLICATION_CREDENTIALS environment variable or Application Default Credentials).
- Low install friction with a pure-wheel distribution.
- Repository is archived and maintenance status is abandoned, which may affect dependency updates and security patch responsiveness.
License · maintenance · safety
Apache 2.0 (permissive) — Licensed under Apache 2.0 (permissive), allowing commercial and private use with minimal restrictions.
last release 2026-08-06 (8 days) · last repo commit 2026-03-06 · 798 stars · archived
0 known vulnerabilities (OSV.dev, 2026-08-14) · 254,119,339 downloads/mo, #156 on PyPI
Alternatives
Verify before relying
pip install google-cloud-bigquery
from google.cloud import bigquery
client = bigquery.Client()
query_job = client.query('SELECT name FROM `bigquery-public-data.usa_names.usa_1910_2013` WHERE state = "TX" LIMIT 100')
rows = query_job.result()- Whether abandoned status reflects actual lack of security patches or is a metadata artifact from Google's internal release process
- Whether the 7 runtime dependencies are themselves actively maintained and receive timely updates
What it is and what it does
google-cloud-bigquery is the official Python client for Google's BigQuery data warehouse service. It provides a programmatic interface to run SQL queries, manage datasets and tables, and retrieve results from BigQuery's infrastructure. The library handles authentication via google-auth, constructs and submits queries, and streams results back to your Python application.
The package depends on google-api-core, google-auth, google-cloud-core, google-resumable-media, requests, python-dateutil, and packaging. It requires Python >= 3.10. The repository is marked archived and maintenance is listed as abandoned; this warrants investigation before adopting for new projects, though the package remains in active use.
Use it for
- Run ad-hoc SQL queries against public or private BigQuery datasets and iterate on results in a Python script or Jupyter notebook.
- Automate data pipeline jobs that extract, transform, and load data into BigQuery tables on a schedule.
- Build analytics dashboards or reporting tools that query BigQuery as a backend data source.
- Perform bulk data operations like inserting rows, updating schemas, or managing dataset permissions programmatically.
- Integrate BigQuery queries into machine learning workflows for feature engineering and data preparation.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, with caution.
The package is widely used (254119339 monthly downloads, top 1000 on PyPI), has no known vulnerabilities, and low install friction. However, the archived repository and abandoned maintenance status mean you should verify that Google continues to ship security and compatibility patches through its internal release process before adopting it for new production systems.
Install
google-cloud-bigquery on PyPI
Before you install
Low install friction with a pure-wheel distribution. Repository is archived and maintenance status is abandoned, which may affect dependency updates and security patch responsiveness.
Requires Python >= 3.10 and Google Cloud authentication credentials configured (via GOOGLE_APPLICATION_CREDENTIALS environment variable or Application Default Credentials).
License in practice
Licensed under Apache 2.0 (permissive), allowing commercial and private use with minimal restrictions.
Quickstart
pip install google-cloud-bigquery
from google.cloud import bigquery
client = bigquery.Client()
query_job = client.query('SELECT name FROM `bigquery-public-data.usa_names.usa_1910_2013` WHERE state = "TX" LIMIT 100')
rows = query_job.result()Verify before relying
- Whether abandoned status reflects actual lack of security patches or is a metadata artifact from Google's internal release process
- Whether the 7 runtime dependencies are themselves actively maintained and receive timely updates
Package facts
| License | Apache 2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 7 packagesgoogle-api-coregoogle-authgoogle-cloud-coregoogle-resumable-mediapackagingpython-dateutilrequests |
| Maintenance | Abandoned 8 days since the last release |
| Last repo commit | repository archived |
| First released | |
| Downloads | 254,119,339 / month, #156 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableIntended Audience :: DevelopersOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Topic :: Internet |
Evidence: google_cloud_bigquery-3.43.0-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 › “sql query large datasets”
- google-cloud-bigqueryPython client library for querying and managing data in Google…
- chdbchDB is an in-process SQL OLAP engine powered by ClickHouse that…
- polars-lts-cpupolars-lts-cpu is a CPU-optimized DataFrame library that executes…
Give your agent the search over MCP, or paste the wish link into any chat.
More Internet packages
Botocore provides low-level, data-driven access to Amazon Web Services APIs, serving as the foundation for the AWS CLI and boto3 libraries.
Install it if you need programmatic access to AWS services.
Provides an async client for AWS services using botocore and aiohttp, allowing you to call AWS APIs asynchronously within asyncio-based applications.
Install it if you need to call AWS services from async Python code; it is the standard way to do so.
Pydantic validates Python data structures against type hints, coercing and checking input at runtime to ensure it matches a declared schema.
Provides a platform-independent file locking mechanism to coordinate access to files across processes and threads.
FastAPI is a Python web framework for building REST APIs using type hints, with automatic request validation, serialization, and interactive API documentation.
Provides common Protocol Buffer message definitions used across Google Cloud APIs, enabling Python clients to interact with Google services.
See also bigquery-magics · pandas-gbq · bigframes · google-cloud-bigquery-storage · google-cloud-bigquery-biglake · google-cloud-dataform · google-cloud-bigquery-datatransfer · google-cloud-bigquery-logging · bigquery-schema-generator · bigquery