59 curated breaking changes across major versions of google-cloud-bigquery. Use this as a migration checklist before bumping dependencies.
default to DATETIME type when loading timezone-naive datetimes from Pandas (#1061)
use nullable `Int64` and `boolean` dtypes in `to_dataframe` (#786)
mark the package as type-checked (#1058)
BigQuery Storage and pyarrow are required dependencies (#776)
In `to_dataframe`, use `dbdate` and `dbtime` dtypes from db-dtypes package for BigQuery DATE and TIME columns (#972)
automatically convert out-of-bounds dates in `to_dataframe`, remove `date_as_object` argument (#972)
remove out-of-date BigQuery ML protocol buffers (#1178)
destination tables are no-longer removed by `create_job` (#891)
Update protoc-generated comments (via synth). ([#270](https://github.com/googleapis/python-bigquery/pull/270))
Add CI secrets manager (via synth). ([#271](https://github.com/googleapis/python-bigquery/pull/271))
Transition the library to microgenerator. ([#278](https://github.com/googleapis/python-bigquery/pull/278))
`Client.list_datasets` returns an iterator of `DatasetListItem`. The API
`Client.list_tables` returns an iterators of `TableListItem`. The API
Add `Table.reference` and `Dataset.reference` properties to get the
Add `to_dataframe()` method to row iterators. When Pandas is installed this
Iterate over a `QueryJob` to wait for and get the query results.
Add `Row.keys()`, `Row.items()`, and `Row.get()`. This makes `Row` act
Add `Client.list_tables`, deprecate `Client.list_dataset_tables`.
Add `Client.insert_rows()` and `Client.insert_rows_json()`, deprecate
Remove `QueryJob.query_results()`. Use `QueryJob.result()` instead.
Remove `Client.query_rows()`. Use `Client.query()` instead.
Parse array parameters that contain a struct type. (#4040)
Parse timestamps in query parameters using canonical format (#3945)
Add `QueryJob.undeclared_query_parameters` property. (#3802)
Populate timeout parameter correctly for queries (#4209)
Query and view operations default to the standard SQL dialect. (#4192)
Add `Table.streaming_buffer` property (#4161)
Client functions related to
Automatically retry idempotent RPCs (#4148, #4178)
Support Sub Second Datetimes in row data (#3901, #3915, #3926), h/t @page1
Support external table configuration (#4182) in query jobs (#4191) and
New `Row` class allows for access by integer index like a tuple, string
Add option for job ID generation with user-supplied prefix (#4198)
Add support for update of dataset access entries (#4197)
Add support for atomic read-modify-write of a dataset using etag (#4052)
Add support for labels to `Dataset` (#4026)
Add support for labels to `Table` (#4207)
Add `TableReference` class (#3942)
Add `DatasetReference` class (#3938, #3942, #3993)
Add `ExtractJob.destination_uri_file_counts` property. (#3803)
Add `client.create_rows_json()` to bypass conversions on streaming writes.
Add `client.get_job()` to get arbitrary jobs. (#3804, #4213)
Add filter to `client.list_datasets()` (#4205)
Add `QueryJob.referenced_tables` property. (#3801)
Add new scalar statistics properties to `QueryJob` (#3800)
Functions to create, get, update, delete datasets and tables moved to the
Adding `google.cloud.bigquery.dbapi` package, which implements PEP-249
`job_name` argument added to `Table.upload_from_file` for setting the job
Updating `author_email` in `setup.py` to `[email protected]`.
Adding `is_nullable` property on `SchemaField`. Can be used to check if a
Adding `Table.view_use_legacy_sql` property. Can be used to create views
`SchemaField` is now immutable. It is also hashable so that it can be used
Updating to `google-cloud-core ~= 0.26`, in particular, the underlying HTTP
Adding dependency on `google-resumable-media` for loading BigQuery tables
Fix inclusion of `tests` (vs. `unit_tests`) in `MANIFEST.in` (#3552)
Using the `requests` transport attached to a Client for for resumable media
Adding `autodetect` property on `LoadTableFromStorageJob` to enable schema
Implementing the Python Futures interface for Jobs. Call `job.result()` to
Removing `results()` method from the `QueryJob` class. Use
Get this data programmatically \u2014 free, no authentication.
curl https://depscope.dev/api/breaking/pypi/google-cloud-bigquery