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

PyPI History

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.

0.6.1 (2021-04-12)

Bug Fixes

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

0.6.0 (2021-04-06)

Features

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

Bug Fixes

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)

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)

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)