Feature

Iceberg external tables now support merge on read. You can now query Iceberg tables with position deletes and equality deletes.

Libraries

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

Python

Changes for google-cloud-bigquery

3.31.0 (2025-03-20)

Features

• Add query text and total bytes processed to RowIterator ( #2140) ( 2d5f932)
• Add support for Python 3.13 ( 0842aa1)

Bug Fixes

• Add property setter for table constraints, #1990 ( #2092) ( f8572dd)
• Allow protobuf 6.x ( 0842aa1)
• Avoid "Unable to determine type" warning with JSON columns in to_dataframe ( #1876) ( 968020d)
• Remove setup.cfg configuration for creating universal wheels ( #2146) ( d7f7685)

Dependencies

• Remove Python 3.7 and 3.8 as supported runtimes ( #2133) ( fb7de39)

Feature

On the Scheduling page, you can now view existing schedules, create new schedules, and perform other actions for data preparations, notebooks, BigQuery pipelines, and scheduled queries. For more information, see Create a pipeline schedule. This feature is generally available (GA).

Feature

You can build BigQuery pipelines (formerly workflows), composed of SQL queries or notebooks, in BigQuery Studio. You can then run these pipelines on a schedule. You can also configure notebook runtimes for a pipeline, share a pipeline, or share a pipeline link. This feature is generally available (GA).

Feature

You can now define a _CHANGE_SEQUENCE_NUMBER for BigQuery change data capture (CDC) to manage streaming UPSERT ordering for BigQuery. This feature is generally available (GA).

Feature

BigQuery now supports subqueries in row level access policies. It also includes support for BigLake managed tables and the BigQuery Storage Read API. This feature is now generally available (GA).

Feature

You can now use BigQuery Data Transfer Service for Search Ads to view Performance Max (PMax) campaign data for the following tables:

• CartDataSalesStats
• ProductAdvertised
• ProductAdvertisedDeviceStats
• ProductAdvertisedConversionActionAndDeviceStats

This feature is generally available (GA).

Feature

You can now configure the repeat frequency of BigQuery Data Transfer Service for Google Ad Manager. This option has a default of every 8 hours and a minimum of every 4 hours. This feature is generally available (GA).

Feature

You can now skip loading match tables for BigQuery Data Transfer Service for Google Ad Manager. If match tables are not needed, you can set parameter load_match_tables to FALSE. This feature is generally available (GA).

Feature

You can include data preparation tasks in BigQuery pipelines that execute your code assets in sequence at a scheduled time. This feature is in Preview.

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