No known security advisories.
The current version has no OSV.dev malware reports and no critical or high-severity vulnerabilities.
sqlalchemy-bigquery has 81.1M monthly downloads and 5K GitHub stars. Version 1.17.0 supports Python <3.15,>=3.10, first published in 2015.
It is actively maintained under a permissive license, last released in May 2026.
It is built on top of google-api-core, google-auth and google-cloud-bigquery. It is used by 55 tracked packages, including apache-airflow-providers-google, sagemaker-studio and airbyte.
Package Insights
Score breakdown - each component scores 0-100, weighted by percentage
Maintenance
100
Popularity
82
Adoption
70
Community
100
Provenance
0
How the maintenance status was determined
Last commit
4 days ago
Monthly downloads
81,110,477
•
Active
Activity within 30 days
Stable
Activity within 31-180 days
Minimal
Activity within 181-365 days, or no activity data
At Risk
No activity for > 365 days, but > 10,000 monthly downloads
Archived
Repository flagged as archived on GitHub
How the popularity category was determined
Monthly downloads
81,110,477
Stars
5,336
Stars per 1k downloads
0.07
•
Industry Standard
> 10,000,000 monthly downloads
Hidden Gem
< 0.5 stars per 1k downloads and > 100,000 monthly downloads
Community Favorite
> 5 stars per 1k downloads
Rising Star
Balanced ratio of stars to downloads
Unknown
Fewer than 1,000 monthly downloads, or no star data
How download momentum is calculated
Week daily avg
2,700,727
Month daily avg
2,703,683
Momentum
-0.1%
((week_daily_avg - month_daily_avg) / month_daily_avg) * 100Python version support tiers
requires_python
<3.15,>=3.10
Cutting Edge
Minimum supported version is 3.12 or newer
•
Modern
Minimum supported version is 3.9, 3.10, or 3.11
Legacy
Supports 3.8 or older (or Python 2)
Unknown
No requires_python specified or unparseable
License categories
License
MIT License
•
Permissive
MIT, Apache, BSD, ISC, Unlicense, CC0, etc.
Copyleft
GPL, LGPL, AGPL, MPL, EPL, etc.
Proprietary
Commercial, all rights reserved, custom EULAs
Unknown
No license specified, or none of the above match
How the release cadence was determined
Last release
60 days ago
Total releases
29
Releases/year
2.6
Rapid
Last release within 365 days and > 12 releases/year
•
Regular
Last release within 365 days
Slow
Last release 366-730 days ago
Stalled
Last release > 730 days ago, or no releases
Unknown
No usable release date available
How contributor risk was determined
Contributors
1,169
Monthly downloads
81,110,477
High Load
≤ 2 contributors and ≥ 50,000 monthly downloads
Moderate Load
< 10 contributors and ≥ 500,000 monthly downloads
Low Load
< 25 contributors and ≥ 5,000,000 monthly downloads, or sole maintainer with ≥ 10,000 monthly downloads
•
Balanced
Enough contributors for the package's popularity
Unknown
No contributor data available
Engagement
89
Issue Burden
81.7
per 1k stars
Discussions
1.3
per 1k stars
Fork Ratio
67.8%
contrib / forks
Stale Release
No
PR Velocity
Quiet
Weekly Downloads
GitHub Stars
Not all downloads include detailed metadata. Breakdowns reflect the subset that does.
Downloads by OS
Linux
2.6M
macOS
216
Windows
168
Python Versions
3.11
25.8%
654.4K
3.10
22.7%
577.6K
3.12
20.7%
525.2K
3.13
16.4%
416.4K
3.14
14.4%
366.7K
Top Countries
1.
US
2.3M
US
2.
DE
26.2K
DE
3.
JP
24.3K
JP
4.
IE
22.3K
IE
5.
IN
22.3K
IN
6.
AU
18.0K
AU
7.
CA
17.3K
CA
8.
SG
16.9K
SG
9.
SE
13.3K
SE
10.
ZA
13.2K
ZA
Dependencies
5
- google-api-core !=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0,>=2.11.1
- google-auth <3.0.0,>=2.14.1
- google-cloud-bigquery <4.0.0,>=3.20.0
- packaging
- sqlalchemy <3.0.0,>=1.4.16
16 optional dependencies
- alembic[alembic]
- alembic[all]
- geoalchemy2[all]
- geoalchemy2[geography]
- google-cloud-bigquery-storage[all]
- google-cloud-bigquery-storage[bqstorage]
- grpcio[bqstorage]
- grpcio[all]
- packaging[all]
- packaging[tests]
- pyarrow[bqstorage]
- pyarrow[all]
- pytz[all]
- pytz[tests]
- shapely[all]
- shapely[geography]
Used By
55
- apache-airflow-providers-google
- sagemaker-studio
- airbyte
- profiles-rudderstack
- ethyca-fides
- fidesplus
- chrontext
- f3-data-models
- qalita-core
- orionbelt-analytics
- terno-dbi
- profiles-mlcorelib
- trilogy-public-models
- continual
- omniload
- amora
- dataops-testgen
- material-ai
- deepnote-toolkit
- llmstudio-tracker
- visivo
- databao-agent
- reflekt
- calitp-data-analysis
- agentmode
- piicatcher
- dbd
- sfn-db-query-builder
- oriona-database-tools
- tulona
- reportify-ifes
- stakenix
- multi-db-query-builder
- jupancon
- weiser-ai
- metricflow-lite
- a-piece-of-shit
- askrita
- telescope-cortex
- scandal
- sparvi-core
- qc2plus
- analytics-agent-connector-bigquery
- zangetsu-data
- pyairbyte-flowfile
- pandasai-bigquery
- toolshop
- matey
- piper-cli
- iflow-mcp-pawankumar94-sql-mcp-server
Package Information
License
MIT License
First Release
March 30, 2015
Last Release
2 months ago
Last Commit
4 days ago
Latest Version
1.17.0
Total Releases
29
Contributors
1,169
Open PRs
123
Archived
No
Author
The Sqlalchemy-Bigquery Authors
Python Versions
3
3.10
3.11
3.12
3.13
3.14
Wheels
py2
py3
Keywords
Tracking Since
January 6, 2026
Data Updated
July 5, 2026
Data Freshness
Fresh