You can now visualize BigQuery graph query results and graph schemas directly in BigQuery Studio, without the need of a notebook environment. This feature is in Preview.
]]>Starting July 25, 2026, the BigQuery Data Transfer Service for Facebook Ads
connector will update the data type
mapping for the ActionValue field in the AdInsightsActions report from INT
to FLOAT.
The following features have been added to Python UDFs during Preview:
RecordBatch interface for improved performance.container_request_concurrency, is available for the CREATE FUNCTION
statement. This option controls the maximum number of concurrent requests
per Python UDF container instance.external_service_costs column in the INFORMATION_SCHEMA.JOBS view and in
the ExternalServiceCosts field in the Job API.You can now migrate metadata from external data catalogs to BigLake tables for Apache Iceberg. This feature supports external data catalogs such as such as Apache Hive Metastore and Apache Iceberg REST Catalog. This feature is in Preview.
You can use the BigQuery MCP server to perform a range of data-related tasks with your AI applications including:
This feature is Generally Available (GA).
You can now publish a BigQuery Conversational Analytics agent in Gemini Enterprise. This feature is in Preview.
You can now use the notebook gallery in the BigQuery web UI as your central hub for discovering and using prebuilt notebook templates. This feature is generally available (GA).
]]>Using folders to organize and control access to single file code assets is generally available (GA). In addition, you can perform bulk move and delete operations, refresh folder contents, and view full breadcrumb paths based on resource permissions. For more information, see Create and manage folders.
]]>Conversational analytics now supports querying Lakehouse tables that connect to the Apache Iceberg REST catalog or are federated to an external catalog. For more information, see Query BigLake data with natural language.
This feature is in Preview.
You can now use Colab Data Apps to transform your data analyses from Colab notebooks into polished, interactive applications.
This feature is in Preview.
You can now use the
AI.KEY_DRIVERS function
to identify segments of data that cause statistically significant changes to a
summable metric.
This feature is in Preview.
]]>BigQuery Apache Iceberg external tables now support Iceberg version 3, including binary deletion vectors. For more information, see Apache Iceberg external tables. This feature is in Preview.
BigQuery agent analytics is now generally available (GA) in the Google Agent Developer Kit. BigQuery agent analytics is an open source solution that lets you capture, analyze, and visualize multimodal agent interaction data at scale.
A known issue has been resolved where a materialized view refresh could expose could expose masked or filtered data from fine grained access control policies in error messages. No further action is needed.
You can now use EXPORT DATA
statements to reverse
ETL BigQuery data to AlloyDB. This feature is
in Preview.
Support for the AI.AGG function preview
has been temporarily disabled. We are working to restore this feature as soon as
possible.
To reduce LLM token consumption and query latency when processing large datasets, enable optimized mode using the following managed AI functions:
This feature is in Preview.
The following managed AI functions use Gemini to help you filter, join, rank, and classify your data:
AI.IF:
Filter and join text and unstructured data (such as images, PDFs, audio, or
video) based on a condition described in natural language.AI.SCORE:
Rate text and unstructured data (such as images, PDFs, audio, or video) to
rank your data by quality, similarity, or other criteria.AI.CLASSIFY:
Classify text and unstructured data (such as images, PDFs, audio, or video)
into user-defined categories.These functions are generally available (GA).
You can use visualization cells to automatically generate a visualization of any DataFrame in your notebook. You can customize the columns, chart type, aggregations, colors, labels, and title.
This feature is generally available (GA).
]]>SQL cells in BigQuery notebooks are now generally available (GA).
]]>The BigQuery Data Transfer Service can now transfer data from Snowflake to BigQuery. This feature is generally available (GA).
You can now use stateful operations in continuous
queries,
which let you perform complex analysis by retaining information across multiple
rows or time intervals using JOINs and windowing aggregations. This feature is
in Preview.
You can now use BigQuery Graph to model your data as a graph and perform analysis on a large scale.
Create a graph directly from tables that store entities and relationships between entities. You don't need to modify your existing workflows or replicate your data to use it in graph queries.
Use Graph Query Language (GQL) to find complex, hidden relationships between data points that would be challenging to find using SQL.
Visualize your graph schema and graph query results in a notebook.
This feature is in Preview.
]]>The BigQuery Data Transfer Service now supports incremental data transfers when transferring data from Microsoft SQL Server to BigQuery. This feature is supported in Preview.
You can now use the
@@session_id system variable with
SQL user-defined functions, table functions, and logical views. This feature is
generally available
(GA).
The BigQuery Data Transfer Service now supports incremental data transfers for the following data source connectors:
These features are supported in Preview.
You can now use the built-in text embedding model embeddinggemma-300m in the
AI.EMBED
and
AI.SIMILARITY
functions. This model uses your BigQuery slots to generate embeddings at scale.
This feature is in
Preview.
You can now use the
AI.AGG function
to semantically aggregate unstructured input data based on natural language
instructions. This feature is in
Preview.
You can now use a custom organization policy to allow or deny specific operations on these BigQuery resources: tables, data policies, and row access policies. This feature is in preview.
]]>You can now use the
CREATE CONNECTION,
ALTER CONNECTION SET OPTIONS,
and DROP CONNECTION
data definition language (DDL) statements to manage Cloud resource connections
with GoogleSQL. Additionally, you can now use the
connection user type
and PROJECT resource type
with GRANT and REVOKE data control language (DCL) statements to manage
connection and project access. These features are
generally available
(GA).
The BigQuery Migration Service supports SQL translations from Snowflake SQL to GoogleSQL. This feature is now generally available (GA).
With this change, the translation service supports a wider variety of
Snowflake SQL and has improved support for several data types.
Among other changes, the translation service maps Snowflake
INTEGER and zero-scale NUMERIC types up to precision 38 to INT64 type in
GoogleSQL for improved performance by default.
You can set the column granularity when you create a search index, which stores additional column information in your search index to further optimize your search query performance. This feature is generally available (GA).
]]>BigQuery ObjectRef values
now support the following:
ObjectRef functions
with either
direct access or delegated access.OBJ.MAKE_REF function
automatically fetches the latest Cloud Storage metadata and populates this in
the ref.details field.OBJ.GET_READ_URL function
returns a STRUCT value with a read URL and status columns and renders image
results in the Cloud console. Use this function when you don't require a
write URL.These features are generally available (GA).
]]>The following forecasting and anomaly detection functions and updates are generally available (GA):
The
AI.DETECT_ANOMALIES function
supports providing a custom context window that determines how many of the
most recent data points should be used by the model.
The
AI.FORECAST function
supports specifying the latest timestamp value for forecasting.
The
AI.EVALUATE function
supports the following:
You can provide a custom context window that determines how many of the most recent data points should be used by the model.
The function outputs the mean absolute scaled error for the time series.
You can now create BigQuery non-incremental materialized views over Spanner data to improve query performance by periodically caching results. This feature is generally available (GA).
]]>You can now use
Cloud resource connections with EXPORT DATA statements
to reverse ETL BigQuery data to Spanner. This
feature is
generally available (GA).
The Gemini for Google Cloud API (cloudaicompanion.googleapis.com) is now enabled for existing BigQuery projects in the European jurisdiction.
You can now use the BigQuery Migration Service MCP server to perform SQL translation tasks, including translating SQL queries into GoogleSQL syntax, generating DDL statements from SQL input queries, and getting explanations of SQL translations.
This feature is in preview.
In BigQuery Data Transfer Service, you can monitor resource-level status reporting for Hive managed tables to track progress and view granular error details for individual tables. This feature is in preview.
You can use the BigQuery migration assessment for Snowflake to assess the complexity of migrating from Snowflake to BigQuery. This feature is generally available (GA).
]]>You can now use the BigQuery Data Transfer Service remote MCP server to enable AI agents to create, manage, and run data transfers. This feature is in Preview.
]]>The following functions are now generally available (GA):
AI.EMBED:
create embeddings from text or image data.AI.SIMILARITY:
compute the semantic similarity between pairs of text, pairs of images, or
across text and images.You can clean, transform, and enrich data from files in Cloud Storage and Google Drive in your BigQuery data preparations. For more information, see Prepare data with Gemini. This feature is generally available (GA).
]]>You can now use a custom organization policy to allow or deny specific operations on routines. This feature is in preview.
]]>In BigQuery ML, you can now automatically deploy open models to Vertex AI endpoints. Automatically deployed models offer the following benefits:
This feature is generally available (GA).
]]>BigQuery now lets you configure a global default location. This setting is used if the location isn't set or can't be inferred from the request. You can set the default location at the organization or project level.
This feature is generally available (GA).
]]>BigQuery advanced runtime is now enabled as the default runtime for all projects.
]]>You can now understand and debug BigQuery query performance with a visual mapping of your SQL query in the query execution graph. A heatmap highlights the steps that consume more slot-time. This feature is generally available (GA).
]]>Updates to conversational analytics include the following improvements:
{'ca-bq-job': 'true'}. These labels can help with the following tasks:
This feature is available in Preview.
]]>You can create a remote model
based on the Vertex AI gemini-embedding-001 model, or a
remote model
based on an open embedding model from Vertex Model Garden or Hugging Face that
is deployed to Vertex AI.
You can then use the
AI.GENERATE_EMBEDDING function
with these remote models to generate embeddings. You can also use the
AI.EMBED function
directly with the gemini-embedding-001 model endpoint.
These features are generally available (GA).
You can now use the Pipelines & Connections page to streamline your data integration tasks by using guided, BigQuery-specific configuration workflows for services like BigQuery Data Transfer Service, Datastream, and Pub/Sub.
This feature is in Preview.
]]>An updated version of the Simba ODBC driver for BigQuery is now available.
You can now use an alternate syntax when you call the
VECTOR_SEARCH function
to improve query performance when you search for a single vector. This feature
is in Preview.
Monitor dataset replication latency and network egress bytes in Cloud Monitoring for BigQuery cross-region replication and managed disaster recovery. These metrics are generally available (GA).
You can now use continuous queries to stream BigQuery data to Spanner in real time. This feature is generally available (GA).
]]>Effective June 1, 2026, BigQuery will limit legacy SQL use. This depends on whether your organization or project uses it from November 1, 2025, to June 1, 2026. If you don't use legacy SQL during this time, you won't be able to use it after June 1, 2026. If you do use it, your existing workloads will keep running, but new ones might not. For more information, see Legacy SQL feature availability.
]]>You can now create and review custom glossary terms in BigQuery for a conversational analytics agent and you can review business glossary terms imported from Dataplex Universal Catalog for an agent. These terms help an agent interpret your prompts.
This feature is now in Preview.
]]>You can now undelete a dataset that is within your time travel window to recover it to the state that it was in when it was deleted. This feature is generally available (GA).
]]>