PyPI · #1162 most downloaded on PyPI

sqlalchemy-bigquery

1.17.310M downloads/mogoogleapis/google-cloud-python ↗New releases in your daily digest, changelog included.

SQLAlchemy dialect for BigQuery

Last release 3 days ago
02 Oct 2026
Ships fairly regularly
a new release about every 2 months
Most releases are documented
notes for 30 of 35 stable releases
Nothing withdrawn
no release was ever pulled
12 years old
40 releases · first in 2015

Release timeline

40 releases since 2015

2015201720192021

Releases

1.17.32 Oct 20262 sources agree
sqlalchemy-bigquery: parallelize compliance tests with worker-partitioned datasets and pytest-xdist
1.17.3 (2026-10-02)

Performance Improvements

sqlalchemy-bigquery: parallelize compliance tests with worker-partitioned datasets and pytest-xdist (#18534) (855bbde)
Open source →
1.17.26 Aug 20262 sources agree
1.17.2 (2026-08-06) Bug Fixes require Protobuf 6.33.5+
1.17.2 (2026-08-06)

Bug Fixes

require Protobuf 6.33.5+ (#17743) (d267342)

From the same repository

googleapis/google-cloud-python

One column per quarter.

1.17.122 Jul 20262 sources agree

sqlalchemy bigquery python 3.15 compat (#17788) (14447fb), closes #17786

1.17.1 (2026-07-22)

Bug Fixes

sqlalchemy bigquery python 3.15 compat (#17788) (14447fb), closes #17786
sqlalchemy-bigquery: update literal binds test for SQLAlchemy 2.0 (#17029) (74f7a41)
sqlalchemy-bigquery: wrap string in WKT in geography system tests (#17780) (26d43c1)

Open source →

1.17.07 May 2026

Drop support for Python 3.8 and 3.9

Bug Fixes

Drop support for Python 3.8 and 3.9 (#16956) (63f6d96c1c5569b5fdaea85dfe995ce280907b98)
Support Creation of JSON columns (#16733) (153b82a47b3db8267e5e546b82a04e7d25e941a0)

pybigquery PyPI History

Open source →

1.16.06 Nov 2025

### Features * Add support for Python 3.14 (#1278) (c09a009) * Remove python 3.8 support

Features

Add support for Python 3.14 (#1278) (c09a009)
Remove python 3.8 support (#1215) (632d6ef)

Open source →

1.15.023 Jun 2025

Add Python 3.13 runtime support

Features

Add Python 3.13 runtime support (#1211) (55336f3)

Open source →

1.14.112 May 2025

Updates _get_transitive_schema_fields and tests

Bug Fixes

Updates _get_transitive_schema_fields and tests (#1200) (16712da)

Open source →

1.14.028 Apr 2025

Allow jobs to be run in a different project

Features

Allow jobs to be run in a different project (#1180) (eea4994)

Bug Fixes

Remove setup.cfg configuration for creating universal wheels (#1175) (dc394ac)

Open source →

1.13.011 Mar 2025

Support job_config at query level

Features

Support job_config at query level (#1167) (ea849e0)

Bug Fixes

Resolve issue where pre-release versions of dependencies are installed (#1169) (8c27cca)

Open source →

1.12.121 Jan 2025

Update partitioning by DATE, DATETIME, TIMESTAMP, _PARTITIONDATE

Features

Update partitioning by DATE, DATETIME, TIMESTAMP, _PARTITIONDATE (#1113) (413cd24)

Bug Fixes

Alembic column rename (#1141) (9f7f78b)
Compilation of a labeled custom FunctionElement when used in grouping (#1155) (4a0f8ad)

Documentation

Fix typo on credentials_info usage sample (#1145) (736d4a2)

Open source →

1.12.02 Oct 2024

Adds user agent parameters to two functions

Features

Adds user agent parameters to two functions (#1100) (f9324e3)
Support UPDATE + JOIN in BigQuery dialect (#1083) (d766d21)
Update colspec to account for sqlalchemy Enum (#1111) (b54bdde)

Bug Fixes

Fix partitioning by DATE column (#1074) (ad69c63)
Implement modulus operator (#1048) (f5fb1a2)
Set cte_follows_insert to True (#1095) (9e0b117)
Use except distinct and intersect distinct (#1094) (80781ef)

Open source →

1.11.018 Apr 2024

Support SQLAlchemy 2.0, raise minimum required version to 1.4.x ([#920](https://github.com/googleapis/python-bigquery-sqlalchemy/pull/920), [#1053](ht

Features

Support SQLAlchemy 2.0, raise minimum required version to 1.4.x ([#920](https://github.com/googleapis/python-bigquery-sqlalchemy/pull/920), [#1053](https://github.com/googleapis/python-bigquery-sqlalchemy/pull/1053)) (7a4c3c2)

Bug Fixes

Fix grouping sets, rollup and cube rendering issue ([#1019](https://github.com/googleapis/python-bigquery-sqlalchemy/pull/1019), [#1053](https://github.com/googleapis/python-bigquery-sqlalchemy/pull/1053)) (7a4c3c2)

Documentation

Fix docs session (#1060) (7e66cc2)

Open source →

1.11.0.dev21 Feb 2024pre-release

Nothing published for this version

1.10.028 Feb 2024

Allow to set clustering and time partitioning options at table creation

Features

Allow to set clustering and time partitioning options at table creation (#928) (c2c2958)

Bug Fixes

Avoid implicit join when using join with unnest (#924) (ac74a34)

Open source →

1.9.011 Dec 2023

1.9.0 (2026-09-24) Features crc32c: support Python 3.15

1.9.0 (2026-09-24)

Features

crc32c: support Python 3.15 (1bf979a)

Open source →

Additional notes

Features

Add support for Python 3.12 (#923) (8952f02)

Bug Fixes

Remove Python 3.7 support due to EOL (#900) (45fcad4)
Removing Python 3.7 from sync-repo-settings.yaml file (#902) (afd895e)

Open source →

1.8.015 Aug 2023

### Features * Remove illegal character check

Features

Remove illegal character check (#892) (3328d0a)

Open source →

1.7.011 Jul 2023

Added regexp_match operator support for bigquery

Features

Added regexp_match operator support for bigquery (#511) (fd78093)
Remove pyarrow and bqstorage as dependencies (#847) (5d6b38c)

Bug Fixes

Avoid aliasing known CTEs (#839) (8a1f694)
Ensure correct alter table alter column statement is generated on data type changes in alembic (#845) (493430a)
Remove "future" dependency (#542) (ba5e244)
Remove type annotations from _struct.py (#733) (27814df)

Documentation

Pass credentials as python dictionary (#737) (074321d)

Open source →

1.6.11 Feb 2023

### Bug Fixes * Ensure repo install

Bug Fixes

Ensure repo install (#741) (75ef9ac)

Open source →

1.6.031 Jan 2023

1.6.0 (2026-10-01) Features declare Python3.15 support

1.6.0 (2026-10-01)

Features

declare Python3.15 support (8775794)

Open source →

Additional notes

Features

Enable support and testing for python 3.11 (#512) (f826d83)

Bug Fixes

Avoid sqlalchemy20 (#736) (0675b1e)

Open source →

1.5.029 Nov 2022

Allow Users to Supply Their Own BigQuery Client

Features

Allow Users to Supply Their Own BigQuery Client (#474) (4f72d4e)

Bug Fixes

deps: Allow pyarrow version 7+ (#479) (0f6be67)
Require python 3.7+ (#468) (52ec808)
Sets cache support to false, removes upper req limit (#499) (be63adc)
Updates test to account for UTC in failing test (#501) (a050ccf)
Use packaging version parser instead of string splitting (#513) (bb7f6a7)

Open source →

1.4.49 Jun 2022

fix changelog header to consistent size

Documentation

fix changelog header to consistent size (#461) (177e70a)

Open source →

1.4.322 Mar 2022

correct license text from Apache to MIT

Bug Fixes

correct license text from Apache to MIT (#436) (dbf7501)

Open source →

1.4.222 Mar 2022

use explicit rather than implicit relative imports

Bug Fixes

use explicit rather than implicit relative imports (#433) (ca20d3d)
use faux_conn rather than engine in unit tests (#431) (275506f)

Dependencies

require google-cloud-bigquery-storage to avoid performance warning (#414) (ff3273f)

Open source →

1.4.17 Mar 2022

deps: require google-api-core>=1.31.5, >=2.3.2

Bug Fixes

deps: require google-api-core>=1.31.5, >=2.3.2 (#419) (52339f7)

Open source →

1.4.022 Feb 2022

Allow base64 encoded credentials in URI

Features

Allow base64 encoded credentials in URI (#410) (e2f9821)

Bug Fixes

POSTCOMPILE expansion in SQLAlchemy 1.4.27+ (#408) (7844813)

Open source →

1.3.05 Jan 2022

### Features * Enable support for 3.10

Features

Enable support for 3.10 (#381) (4b3505b)

Open source →

1.2.217 Nov 2021

avoid aliasing known tables used in CTEs

Bug Fixes

avoid aliasing known tables used in CTEs (#369) (4b05d21)

Open source →

1.2.127 Oct 2021

avoid creating aliases for already-known tables

Bug Fixes

avoid creating aliases for already-known tables (#361) (1ce4e14)
avoid scribbling on (reused) bind param (#365) (d28cac5)
include external tables in 'get_table_names' (#363) (5e158fe)

Open source →

1.2.09 Sept 2021

the unnest function lost needed type information

Features

STRUCT and ARRAY support (#318) (6624b10)

Bug Fixes

the unnest function lost needed type information (#298) (1233182)

Open source →

1.1.026 Aug 2021

Handle passing of arrays to in statements more efficiently in SQLAlchemy 1.4 and higher

Features

Add geography support (#228) (da7a403)
Handle passing of arrays to in statements more efficiently in SQLAlchemy 1.4 and higher (#253) (7692704)

Bug Fixes

dialect atribute wasn't provided (#291) (2cf05a0)
distinct doesn't work as a column wrapper (#275) (ad5baf8)
in-operator literal binds not handled properly (#285) (e06bf74)
supports_multivalues_insert dialect option was mispelled (#278) (ec36a12)
unnest failed in some cases (with table references failed when there were no other references to refrenced tables in a query) (#290) (9b5b002)

Open source →

1.0.017 Aug 2021

### Miscellaneous Chores * release 1.0.0

Miscellaneous Chores

release 1.0.0 (#249) (d23ae1d)

Open source →

1.0.0a112 Aug 2021pre-release

Rename pybigquery to sqlalchemy-bigquery

Features

Rename pybigquery to sqlalchemy-bigquery (#198) (a6f0a5d)

Miscellaneous Chores

release 1.0.0-a1 (#238) (b630293)

Open source →

0.0.72 Nov 2015

Nothing published for this version

0.0.62 Sept 2015

Nothing published for this version

0.0.52 Apr 2015

Nothing published for this version

0.0.42 Apr 2015

Nothing published for this version

0.0.3

Nothing published for this version

0.0.2dev30 Mar 2015pre-release

Nothing published for this version

0.0.1adevpre-release

Nothing published for this version

0.0.1dev30 Mar 2015pre-release

Nothing published for this version

Your coding agent can read these notes before it upgrades. Set up the MCP server →

google-cloud-storagePyPI

Google Cloud Storage API client library

sqlalchemy-bigquery

Release timeline

Releases

1.17.3 (2026-10-02)

Performance Improvements

1.17.2 (2026-08-06)

Bug Fixes

From the same repository

1.17.1 (2026-07-22)

Bug Fixes

Bug Fixes

Features

Features

Bug Fixes

Features

Bug Fixes

Features

Bug Fixes

Features

Bug Fixes

Documentation

Features

Bug Fixes

Features

Bug Fixes

Documentation

Features

Bug Fixes

1.9.0 (2026-09-24)

Features

Features

Bug Fixes

Features

Features

Bug Fixes

Documentation

Bug Fixes

1.6.0 (2026-10-01)

Features

Features

Bug Fixes

Features

Bug Fixes

Documentation

Bug Fixes

Bug Fixes

Dependencies

Bug Fixes

Features

Bug Fixes

Features

Bug Fixes

Bug Fixes

Features

Bug Fixes

Features

Bug Fixes

Miscellaneous Chores

Features

Miscellaneous Chores