As of January 1, 2020 this library no longer supports Python 2 on the latest released version. Library versions released prior to that date will continue to be available. For more information please visit Python 2 support on Google Cloud.

Changelog

Older versions of this project were distributed as pybigquery.

sqlalchemy-bigquery PyPI History

pybigquery PyPI History

1.12.0 (2024-08-14)

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

1.11.0 (2024-04-12)

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

1.10.0 (2024-02-27)

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)

1.9.0 (2023-12-10)

Features

Bug Fixes

  • Remove Python 3.7 support due to EOL (#900) (45fcad4)

  • Removing Python 3.7 from sync-repo-settings.yaml file (#902) (afd895e)

1.8.0 (2023-08-11)

Features

1.7.0 (2023-07-11)

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)

1.6.1 (2023-02-01)

Bug Fixes

1.6.0 (2023-01-30)

Features

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

Bug Fixes

1.5.0 (2022-11-29)

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)

1.4.4 (2022-06-03)

Documentation

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

1.4.3 (2022-03-22)

Bug Fixes

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

1.4.2 (2022-03-22)

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)

1.4.1 (2022-03-07)

Bug Fixes

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

1.4.0 (2022-02-22)

Features

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

Bug Fixes

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

1.3.0 (2021-12-31)

Features

1.2.2 (2021-10-29)

Bug Fixes

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

1.2.1 (2021-10-27)

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)

1.2.0 (2021-09-09)

Features

Bug Fixes

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

1.1.0 (2021-08-25)

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)

1.0.0 (2021-08-17)

Miscellaneous Chores

1.0.0-a1 (2021-08-11)

Features

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

Miscellaneous Chores

pybigquery 0.10.1 (2021-07-30)

Bug Fixes

  • deps: pin ‘google-{api,cloud}-core’, ‘google-auth’ to allow 2.x versions (#220) (bf1f47c)

pybigquery 0.10.0 (2021-07-06)

Features

  • There’s a new page_size option to control the page size used when listing tables. (#174) (e0f1496)

pybigquery 0.9.1 (2021-06-25)

Documentation

  • omit mention of Python 2.7 in ‘CONTRIBUTING.rst’ (d52334c)

pybigquery 0.9.0 (2021-05-25)

Features

  • Alembic support (#183) (4d5a17c)

  • Support parameterized NUMERIC, BIGNUMERIC, STRING, and BYTES types (#180) (d118238)

pybigquery 0.8.0 (2021-05-21)

Features

pybigquery 0.7.0 (2021-05-12)

Features

  • Comment/description support, bug fixes and better test coverage (#138) (fb7c188)

    • Runs SQLAlchemy dialect-compliance tests (as system tests).

    • 100% unit-test coverage.

    • Support for table and column comments/descriptions (requiring SQLAlchemy 1.2 or higher).

    • When executing parameterized queries, the new BigQuery DB API parameter syntax is used to pass type information. This is helpful when the DB API can’t determine type information from values, or can’t determine it correctly.

Bug Fixes

  • Select expressions no-longer force use of labels (#129) (669b301)

  • Additional fixes, including:

    • Handling of in queries.

    • String literals with special characters.

    • Use BIGNUMERIC when necessary.

    • Missing types: BIGINT, SMALLINT, Boolean, REAL, CHAR, NCHAR, VARCHAR, NVARCHAR, TEXT, VARBINARY, DECIMAL

    • Literal bytes, dates, times, datetimes, timestamps, and arrays.

    • Get view definitions.

pybigquery 0.6.1 (2021-04-12)

Bug Fixes

  • use project_id property from service account credentials (#120) (ab2051d)

pybigquery 0.6.0 (2021-04-06)

Features

  • fetch table and column descriptions during reflection (#115) (7b14a06)

Bug Fixes

pybigquery 0.5.1 (2021-04-01)

Bug Fixes

  • avoid 404 if dataset is deleted while listing tables or views (#106) (db379d8)

Documentation

  • add templates for move to googleapis/python-bigquery-sqlalchemy repo (#88) (37e584e)

  • build documentation with Sphinx (#97) (1707737)

pybigquery 0.5.0 (2020-11-18)

⚠️ Breaking Changes ⚠️

  • get_table_names() no longer returns views. (#62, #60)

Features

  • Support the ARRAY data type in generated DDL. (#64)

  • Support project ID and dataset ID in schema argument. (#63)

  • Implement get_view_names() method. (#62, #60)

Bug Fixes

  • Ignore no-op nested labels. (#47)

Development

  • Use flake8 for code style checks. (#71)

pybigquery 0.4.15 (2020-04-23)

Implementation Changes

  • Prefer explicitly provided dataset over default dataset in lookup. (#53)

  • Use the provided project_id when using a service account. (#52)