October 09, 2023

[github-actions]

Libraries

A weekly digest of client library updates from across the Cloud SDK.

Go

Changes for bigquery/storage/apiv1beta1

1.56.0 (2023-10-05)

Features

• bigquery/analyticshub: Add Subscription resource and RPCs ( #8612) ( 9992249)
• bigquery: Add external dataset reference ( #8545) ( 1001acf)
• bigquery: Add media options to LoadConfig ( #8640) ( 62baf56)

Bug Fixes

• bigquery/storage/managedwriter: Automatic retry for multiplex test ( #8601) ( 6ef1945)
• bigquery: Dependency detection on proto conversion ( #8566) ( 763ab5d)

Documentation

• bigquery/datatransfer: Update transferConfig.name description to indicate that it supports both formats ( 0449518)

Python

Changes for google-cloud-bigquery

3.12.0 (2023-10-02)

Features

• Add Dataset.storage_billing_model setter, use client.update_dataset(ds, fields=["storage_billing_model"]) to update ( #1643) ( 5deba50)
• Search statistics ( #1616) ( b930e46)
• Widen retry predicate to include ServiceUnavailable ( #1641) ( 3e021a4)

Bug Fixes

• Allow storage_billing_model to be explicitly set to None to use project default value ( #1665) ( 514d3e1)
• Relax timeout expectations ( #1645) ( 1760e94)
• Use isinstance() per E721, unpin flake8 ( #1659) ( 54a7769)

Documentation

• Revise update_table_expiration sample ( #1457) ( 03194e0)

Feature

Queries now support additional ways to work with grouping sets, which include:

• GROUP BY GROUPING SETS clause (new): Produce aggregated data for one or more
  grouping sets.
• GROUP BY CUBE clause (new): Produce aggregated data for all grouping set
  permutations.
• GROUP BY ROLLUP clause (update): You can now include groupable items sets in this clause.
• GROUPING function (new): Check if a groupable value in the GROUP BY clause is aggregated.

This feature is in preview.

Feature

Adding descriptions to the columns of a view is now generally available (GA). Use the CREATE VIEW or ALTER COLUMN DDL statements to add descriptions.

Changed

BigQuery is now available in the Dammam (me-central2) region.

Changed

BigQuery ML is now available in the Dammam (me-central2) region.

Changed

BigQuery Data Transfer Service is now available in the Dammam (me-central2) region.

https://cloud.google.com/bigquery/docs/release-notes#October_09_2023