Iceberg external tables now support merge-on-read. You can query Iceberg tables with position deletes and equality deletes
Share
Services
## Feature
[Iceberg external tables](https://cloud.google.com/bigquery/docs/iceberg-external-tables) now support merge-on-read. You can query Iceberg tables with position deletes and equality deletes. This feature is [generally available](https://cloud.google.com/products#product-launch-stages) (GA).
## Library
A weekly digest of client library updates from across the [Cloud SDK](https://cloud.google.com/sdk).
### Python
### Changes for [google-cloud-bigquery](https://github.com/googleapis/python-bigquery)
#### [3.31.0](https://github.com/googleapis/python-bigquery/compare/v3.30.0...v3.31.0) (2025-03-20)
##### Features
* Add query text and total bytes processed to RowIterator ([#2140](https://github.com/googleapis/python-bigquery/issues/2140)) ([2d5f932](https://github.com/googleapis/python-bigquery/commit/2d5f9320d7103bc64c7ba496ba54bb0ef52b5605))
* Add support for Python 3.13 ([0842aa1](https://github.com/googleapis/python-bigquery/commit/0842aa10967b1d8395cfb43e52c8ea091b381870))
##### Bug Fixes
* Add property setter for table constraints, [#1990](https://github.com/googleapis/python-bigquery/issues/1990) ([#2092](https://github.com/googleapis/python-bigquery/issues/2092)) ([f8572dd](https://github.com/googleapis/python-bigquery/commit/f8572dd86595361bae82c3232b2c0d159690a7b7))
* Allow protobuf 6.x ([0842aa1](https://github.com/googleapis/python-bigquery/commit/0842aa10967b1d8395cfb43e52c8ea091b381870))
* Avoid "Unable to determine type" warning with JSON columns in `to_dataframe` ([#1876](https://github.com/googleapis/python-bigquery/issues/1876)) ([968020d](https://github.com/googleapis/python-bigquery/commit/968020d5be9d2a30b90d046eaf52f91bb2c70911))
* Remove setup.cfg configuration for creating universal wheels ([#2146](https://github.com/googleapis/python-bigquery/issues/2146)) ([d7f7685](https://github.com/googleapis/python-bigquery/commit/d7f76853d598c354bfd2e65f5dde28dae97da0ec))
##### Dependencies
* Remove Python 3.7 and 3.8 as supported runtimes ([#2133](https://github.com/googleapis/python-bigquery/issues/2133)) ([fb7de39](https://github.com/googleapis/python-bigquery/commit/fb7de398cb2ad000b80a8a702d1f6539dc03d8e0))
## 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](https://cloud.google.com/bigquery/docs/orchestrate-workflows#create-schedule). This feature is [generally available](https://cloud.google.com/products#product-launch-stages) (GA).
## Feature
You can [build BigQuery pipelines](https://cloud.google.com/bigquery/docs/workflows-introduction) (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](https://cloud.google.com/products#product-launch-stages) (GA).
## Feature
You can now define a [\_CHANGE\_SEQUENCE\_NUMBER](https://cloud.google.com/bigquery/docs/change-data-capture#manage%5Fcustom%5Fordering) for BigQuery change data capture (CDC) to manage streaming `UPSERT` ordering for BigQuery. This feature is [generally available](https://cloud.google.com/products/#product-launch-stages) (GA).
## Feature
BigQuery now supports [subqueries](https://cloud.google.com/bigquery/docs/reference/standard-sql/subqueries) in [row level access policies](https://cloud.google.com/bigquery/docs/managing-row-level-security#create%5For%5Fupdate%5Fa%5Frow-level%5Faccess%5Fpolicy). It also includes support for [BigLake managed tables](https://cloud.google.com/bigquery/docs/biglake-intro) and the [BigQuery Storage Read API.](https://cloud.google.com/bigquery/docs/reference/storage) This feature is now [generally available](https://cloud.google.com/products/#product-launch-stages) (GA).
## Feature
You can now use [BigQuery Data Transfer Service for Search Ads](https://cloud.google.com/bigquery/docs/search-ads-transfer#pmax-support) to view [Performance Max (PMax) campaign data](https://support.google.com/google-ads/answer/10724817) for the following tables:
* CartDataSalesStats
* ProductAdvertised
* ProductAdvertisedDeviceStats
* ProductAdvertisedConversionActionAndDeviceStats
This feature is [generally available](https://cloud.google.com/products#product-launch-stages) (GA).
## Feature
You can now configure the repeat frequency of [BigQuery Data Transfer Service for Google Ad Manager](https://cloud.google.com/bigquery/docs/doubleclick-publisher-transfer). This option has a default of every 8 hours and a minimum of every 4 hours. This feature is [generally available](https://cloud.google.com/products#product-launch-stages) (GA).
## Feature
You can now skip loading match tables for [BigQuery Data Transfer Service for Google Ad Manager](https://cloud.google.com/bigquery/docs/doubleclick-publisher-transfer). If match tables are not needed, you can set parameter `load_match_tables` to `FALSE`. This feature is [generally available](https://cloud.google.com/products#product-launch-stages) (GA).
## Feature
You can include data preparation tasks in [BigQuery pipelines](https://cloud.google.com/bigquery/docs/workflows-introduction) that execute your code assets in sequence at a scheduled time. This feature is in [Preview](https://cloud.google.com/products#product-launch-stages).
What else is happening at Google Cloud Platform?
The Execution: Ingress Nightmare Vulnerability Execution detector of Container Threat Detection is in Preview
about 12 hours ago
Services
Share
A weekly digest of client library updates from across the Cloud SDK
about 12 hours ago
Services
Share
A weekly digest of client library updates from across the Cloud SDK
about 15 hours ago
Services
Share
A weekly digest of client library updates from across the Cloud SDK
about 17 hours ago
Services
Share