August 07, 2023

[github-actions]

Feature

The quantitive LIKE operator is now in
preview. With this operator, you can check a search value for matches against several patterns, using one of these conditions:

• LIKE ANY: Checks if at least one pattern matches.
• LIKE SOME: Synonym for LIKE ANY.
• LIKE ALL: Checks if every pattern matches.

Feature

The following JSON functions are now generally available (GA).

• JSON_ARRAY: Creates a JSON array.
• JSON_ARRAY_APPEND: Appends JSON data to the end of a JSON array.
• JSON_ARRAY_INSERT: Inserts JSON data into a JSON array.
• JSON_OBJECT: Creates a JSON object.
• JSON_REMOVE: Produces JSON with the specified JSON data removed.
• JSON_SET: Inserts or replaces JSON data.
• JSON_STRIP_NULLS: Removes JSON nulls.
• LAX_BOOL: Attempts to convert a JSON value to a SQL BOOL value.
• LAX_FLOAT64: Attempts to convert a JSON value to a
  SQL FLOAT64 value.
• LAX_INT64: Attempts to convert a JSON value to a SQL INT64 value.
• LAX_STRING: Attempts to convert a JSON value to a SQL STRING value.

Feature

BigQuery now supports the ability to deny access to principals via deny policies for the following IAM permissions :

• Managing reservations and capacity commitments: bigquery.googleapis.com/capacityCommitments.*, bigquery.googleapis.com/bireservations.*, bigquery.googleapis.com/reservationAssignments.*, bigquery.googleapis.com/reservations.*
• Resource Deletion: bigquery.googleapis.com/[datasets, tables, models, routines, jobs, connections].delete
• Dataset tag bindings: bigquery.googleapis.com/datasets.[createTagBinding, listTagBinding]
• Row Access Policies: bigquery.rowAccessPolicies.[create, delete, update, setIamPolicy]

Libraries

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

Node.js

Changes for @google-cloud/bigquery

7.1.1 (2023-08-03)

Bug Fixes

• Node release schedule link ( #1241) ( 3bcb08a)
• Update @types/big.js ( 8d16fae)

7.1.0 (2023-08-01)

Features

• Support and optionally parse JSON field ( #1229) ( cd11447)
• Support create/list datasets on a different project ( #1230) ( 86c63fb)

7.0.0 (2023-07-31)

⚠ BREAKING CHANGES

• migrate to node 14 ( #1236)

Bug Fixes

• deps: Update dependency google-auth-library to v9 ( #1228) ( 22cf786)

Miscellaneous Chores

• Migrate to node 14 ( #1236) ( 73bf31f)

Feature

Analytics Hub now supports the use of routines in linked datasets. This feature is now in preview.

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