February 26, 2024

[github-actions]

Libraries

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

Java

Changes for google-cloud-bigquery

2.38.0 (2024-02-22)

Features

• Add MetadataCacheStatistics to Job QueryStatistics ( #3133) ( f3f387b)

Dependencies

• Update dependency com.google.apis:google-api-services-bigquery to v2-rev20240211-2.0.0 ( #3152) ( e5d6888)
• Update github/codeql-action action to v2.24.3 ( #3148) ( a0a7b01)
• Update github/codeql-action action to v2.24.3 ( #3150) ( 042fcf0)
• Update github/codeql-action action to v2.24.4 ( #3161) ( 531b1a0)

Feature

The BigQuery Data Transfer Service can now transfer data from the following data sources:

• Facebook Ads
• Oracle
• Salesforce
• Salesforce Marketing Cloud
• ServiceNow

Transfers from these data sources are supported in preview.

Feature

The following SQL features are now generally available (GA):

• GROUP BY GROUPING SETS clause: Produces aggregated data for one or more grouping sets.
• GROUP BY CUBE clause: Produces aggregated data for all grouping set permutations.
• GROUPING function: Checks if a groupable value in the GROUP BY clause is aggregated.

Feature

The GROUP BY ALL clause, which groups rows by inferring grouping keys from the SELECT items, is now in preview.

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