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

## 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).