BigQuery News & Updates for March 2025

Google Updates BigQuery with New Pipelines, Version Control, and Claude AI Integration

1 days ago

Google has introduced major updates to BigQuery, including renaming workflows to pipelines and adding version control capabilities. Workflows are now called pipelines, with documentation available. New version control features in preview allow users to manage file versions using Git and edit code in workspaces. Additionally, BigQuery ML supports remote models based on the Anthropic Claude model, enabling advanced AI text generation tasks.

BigQuery Makes Analytics Hub Egress Controls and Data Clean Room Subscriptions Widely Available

14 days ago

BigQuery

BigQuery has announced that Analytics Hub egress controls and data clean room subscriptions are now available in all editions and with on-demand pricing. This expansion broadens access to data sharing and protection features. Egress controls allow publishers to restrict how subscribers can export data from linked datasets. Data clean rooms create secure environments for sharing and analyzing sensitive data without revealing it, now accessible across all editions.

BigQuery Data Transfer Service adds custom reports support for Google Ads

18 days ago

Google Ads BigQuery

BigQuery Data Transfer Service now supports custom reports for Google Ads using Google Ads Query Language (GAQL) in transfer configurations. This feature allows ingestion of custom reports and fields beyond standard options and is generally available. The connector supports custom reports from all resources in the Google Ads API. Limitations include unsupported clauses like WHERE and ORDER BY, automatic appending of date segments, and restrictions on backfill runs.

Marketing Workflows Powered by AI

Featured

Markifact is a no-code marketing automation platform that lets users create AI-driven workflows for automating marketing tasks. Users can trigger workflows, connect apps, and track performance through a visual interface. The platform offers pre-built templates, integrates with various marketing tools, and supports team collaboration.

Google Enhances Gemini in BigQuery with Python Code Completion

21 days ago

Gemini BigQuery

Google has enhanced Gemini in BigQuery with a new Python code completion feature that offers contextually relevant suggestions. This aids users in writing Python code more efficiently within BigQuery notebooks. To access it, users navigate to BigQuery Studio, select Python notebook, and type code to receive inline suggestions. Users can also customize their experience by managing Gemini features in the BigQuery toolbar, highlighting Google's focus on improving productivity.

BigQuery Enhances Resource Utilization Charts with New Metrics and Configuration Options

27 days ago

BigQuery

BigQuery has introduced resource utilization charts in Preview, providing metrics views and enhanced configuration options. These charts help track past resource use for planning and troubleshooting. They gather data from INFORMATION_SCHEMA views and can be updated in real time for up to 30 days. Users can configure event timelines and select metrics like slot usage, with status chips indicating loading and errors.

Google Launches Gemini AI-Powered Join Operations in BigQuery Data Preparation

1 months ago

Gemini BigQuery

Google has launched a Preview feature in BigQuery that uses Gemini AI for intelligent join operation recommendations. It provides context-aware suggestions and natural language processing for accurate joins, generating SQL expressions and descriptions. Users can access it in the data view interface, select join types, and preview results. The system defaults to a Cross join if no conditions are specified, allowing users to refine their options.

BigQuery Introduces JavaScript User-Defined Aggregate Functions

1 months ago

BigQuery

Google has announced the general availability of JavaScript User-Defined Aggregate Functions (UDAF) in BigQuery, allowing users to create custom aggregate functions using JavaScript. The process requires JavaScript code as a quoted string and implementation of four essential functions: initialState, aggregate, merge, and finalize. Persistent UDAFs are reusable, secure, and maintain data integrity. Users must use the CREATE AGGREGATE FUNCTION statement and include the dataset in the path.

BigQuery Enhances ML Bucketing Function and Set Operation Features

1 months ago

BigQuery

Google has improved its BigQuery ML platform with new features for bucketing functions and set operations. The ML.BUCKETIZE and ML.QUANTILE_BUCKETIZE functions now allow customizable output formatting through the output_format argument, supporting string format, interval notation, or JSON. Additionally, the BY NAME and CORRESPONDING modifiers are now available for set operations, enabling column matching by name and simplifying data manipulation.

BigQuery Adds Stored Column Usage Tracking for Vector Search Queries

1 months ago

BigQuery

Google launched a feature for BigQuery that tracks stored column usage in vector search queries. The StoredColumnsUsage feature includes three parts: reasons for unused columns, whether they sped up query execution, and the main table referenced. It employs a JSON structure to monitor these metrics, offering insights into query performance and stored column use, thus improving BigQuery's vector search capabilities.

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?