This repository was archived by the owner on Sep 23, 2025. It is now read-only.
This repository was archived by the owner on Sep 23, 2025. It is now read-only.
September 16, 2025 #578
Description
Feature
You can now access snapshots of Apache Iceberg external tables that are retained in your Iceberg metadata by using the FOR SYSTEM_TIME AS OF clause. This feature is generally available (GA).
Feature
You can use the JSON_KEYS function to extract unique JSON keys from a JSON expression, and you can specify a mode for some JSON functions that take a JSONPath to allow more flexibility in how the path matches the JSON structure. These features are generally available (GA).
Feature
SQL code completion is now available for all BigQuery projects. To learn how to enable and activate Gemini in BigQuery features, see Set up Gemini in BigQuery. This feature is available in preview.
https://cloud.google.com/bigquery/docs/release-notes#September_16_2025