[BQ] February 06, 2023

[github-actions]

Feature

The HAVING MAX and HAVING MIN clause for the ANY\_VALUE function is now in preview.

Feature

You can now view information related to query processing to monitor and optimize queries with the query\_info column in [INFORMATION\_SCHEMA.JOBS](https://cloud.google.com/bigquery/docs/information-schema-jobs), [JOBS\_BY\_FOLDER](https://cloud.google.com/bigquery/docs/information-schema-jobs-by-folder) and [JOBS\_BY\_ORGANIZATION](https://cloud.google.com/bigquery/docs/information-schema-jobs-by-organization) views. This feature is generally available (GA).

Libraries

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

Python

Changes for google-cloud-bigquery

3.5.0 (2023-01-31)

Features

• Add str method to DatasetReference (#1477) (f32df1f)
• Add preserveAsciiControlCharacter to LoadJobConfig (#1484) (bd1da9a)

Documentation

• Adds snippet for creating table with external data config (#1420) (f0ace2a)
• Revise delete label table code sample, add TODO to clean up sni… (#1466) (0dab7d2)
• samples: Table variable fix (#1287) (a71888a)

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