BigQuery News & Updates for December 2025

BigQuery Data Transfer Service Supports Incremental Transfers from Salesforce in Preview

8 days ago

The BigQuery Data Transfer Service now supports incremental data transfers from Salesforce to BigQuery in preview. Users can choose Full or Incremental write preferences when setting up transfers. Incremental transfers only move changed data since the last transfer and require specifying Append or Upsert write modes. Append mode adds new rows and needs a watermark column like CreatedDate to track changes, but may cause duplicates.

Google unveils Conversational Analytics API to chat with data anywhere

3 months ago

BigQuery Looker Studio +1 more

Google Cloud's Conversational Analytics API, in public preview, lets developers embed natural language queries into apps using trusted data from Looker and BigQuery. It combines AI with Looker's semantic model for accurate, context-aware insights accessible anywhere. Features include text-to-SQL, code interpretation, charting, AI-assisted context, multi-agent support, role-based access, and query controls for seamless, secure data interaction.

BigQuery Data Transfer Service adopts consumption-based pricing for third-party connectors

3 months ago

BigQuery

Starting September 25, 2025, BigQuery Data Transfer Service for third-party SAAS and database connectors will switch to consumption-based pricing, charging based on compute resources used, measured in slot-hours. This applies to connectors like Facebook Ads, MySQL, Oracle, PostgreSQL, Salesforce, Salesforce Marketing Cloud, ServiceNow, and others planned for future release.

BigQuery Reference Panel Adds Schema Preview and Query Editing Features

3 months ago

BigQuery

The BigQuery console's Reference panel lets users preview schema details of tables, snapshots, views, and materialized views in both query and notebook editors. It allows opening these resources in new tabs and helps construct or edit queries by inserting snippets or field names. The panel dynamically shows context-aware info and supports searching and inserting query elements directly in the editor. This feature is generally available.

Automate Meta Ads Creative Generation and Uploading

Featured

Markifact automates the creation and uploading of Meta ads using AI. Users generate custom visuals and matching ad copy by writing detailed prompts and uploading reference images. Ads are uploaded in a paused status for review before going live. This tool allows for quick creation of multiple ad variations, adaptation to market trends, and scaling of campaigns without needing extensive design or copywriting resources.

BigQuery adds Gemini-powered data aggregation in Preview for easier data prep

3 months ago

BigQuery

You can use Gemini in BigQuery to aggregate table data during data preparation, currently in Preview. Choose Aggregate in data or schema view, enter a prompt like total revenue, and send it. Gemini creates grouping keys and aggregation expressions, which you can edit or add manually. Grouping keys need aliases and no duplicates; aggregation expressions also require aliases and no duplicates. Preview and apply the step.

BigQuery adds WITH expressions for temporary variables in GoogleSQL queries

3 months ago

BigQuery

BigQuery now supports WITH expressions in GoogleSQL to create temporary variables within queries. Variables are assigned once and can be used in subsequent expressions but not as arguments in aggregate or analytic functions. Each variable is evaluated once. This feature differs from WITH clauses and allows for cleaner, modular queries with examples showing concatenation, random value evaluation, and aggregate calculations.

BigQuery Update Enabling advanced runtime with short query optimizations in preview

3 months ago

BigQuery

BigQuery's advanced runtime now includes short query optimizations in preview, which reduce latency and slot use by running some queries as a single stage. These optimizations depend on data scan size, data movement, filter selectivity, data layout, query structure, and past execution stats. Enable or disable this runtime using ALTER PROJECT or ALTER ORGANIZATION statements with query_runtime set to 'advanced' or NULL. Changes take minutes to apply.

BigQuery Introduces New Vector Index Management and Data Loading Features

4 months ago

BigQuery

BigQuery introduces VECTOR_INDEX.STATISTICS to track data drift and ALTER VECTOR INDEX REBUILD for index maintenance, both in Preview. Access Transparency now covers BigQuery data prep in GA. New Preview options for CREATE EXTERNAL TABLE and LOAD DATA include null_markers for NULL strings and source_column_match for column mapping. MATCH_RECOGNIZE clause adds pattern recognition in SQL queries, enhancing analytical capabilities.

BigQuery launches DISTINCT pipe operator for selecting unique rows in queries

4 months ago

BigQuery

BigQuery now supports the DISTINCT pipe operator in pipe syntax queries, which returns distinct rows from an input table while preserving table aliases. It works like SELECT DISTINCT or UNION DISTINCT but can be used anywhere in the query. It computes distinct rows based on all visible columns, ignoring pseudo-columns, and does not expand value table fields. This feature is generally available.

BigQuery News

FAQs

What are the top BigQuery updates I must know about in 2025?

What are the latest BigQuery news this month?

What are the best BigQuery tools that I should use?

What's the best source for BigQuery news and updates?

Is there a BigQuery newsletter I can subscribe to?