BigQuery News & Updates for May 2025

Google Enhances BigQuery with Continuous Queries and Cross-Regional Federated Queries

7 days ago

Google BigQuery offers continuous queries for real-time data processing and ML inference, outputting to BigQuery, Pub/Sub, or Bigtable. It supports multiple ingestion methods, monitoring, and autoscaling. Use cases include personalized messaging, anomaly detection, event-driven pipelines, data enrichment, and reverse ETL. Spanner supports cross-regional federated queries from BigQuery, enabling cross-region queries without egress fees in preview.

BigQuery launches Snowflake transfer scheduling preview and cross-region data transfer GA

11 days ago

BigQuery

BigQuery now allows scheduling automated data transfers from Snowflake using the Data Transfer Service, currently in preview, staging data in the same cloud or Amazon S3 for AWS accounts. It supports cross-region batch loading and exporting data across any regions with simple commands, now generally available. Vector indexes support the TreeAH type with Google's ScaNN algorithm for efficient batch processing of many embeddings, also generally available.

BigQuery Now Shows Query Text in Execution Graph

12 days ago

BigQuery

BigQuery has introduced a feature allowing users to view Query text within the Execution graph. This shows which part of the SQL corresponds to each stage step, helping identify bottlenecks. Users can see the source of each subquery, what data was read, aggregated, or written, and understand why certain steps, like the "0.28 sec Input," may be causing delays. This small UI update significantly aids in debugging and performance tuning.

Tired of spending too much time creating audits for your clients?

Featured

Marketing Auditor simplifies your audit process, letting you generate comprehensive, white-label reports in just a few clicks. Save over 10 hours per report while analyzing 200+ data points and delivering 50+ pages of actionable insights. Customize reports with professional themes or your own branding, and export them in editable formats like PowerPoint or Google Slides to showcase your expertise.

BigQuery Introduces Enhanced SQL Group By Features for STRUCTs and ARRAYs

13 days ago

BigQuery

Google has announced new SQL features in BigQuery that enhance data grouping and query flexibility. The GROUP BY STRUCT feature allows grouping of STRUCT types if all fields are groupable, applicable only in GROUP BY or SELECT DISTINCT clauses. The GROUP BY ARRAY feature supports ARRAY types under similar conditions. Additionally, the GROUP BY ALL clause infers grouping keys from SELECT items while excluding expressions with aggregate or window functions.

Google Enhances BigQuery with New Monitoring Tools and Multimodal Analysis Features

14 days ago

BigQuery

'Google has enhanced BigQuery with improved resource monitoring tools, including a six-hour event timeline and a new reservation slot usage view for better resource management. Users can visualize query execution flows more effectively with the new Query text section. Additionally, BigQuery now supports multimodal analysis and transformation workflows in SQL and Python, allowing integration of unstructured data and generative AI for analysis.

Google Introduces Autosave Feature for BigQuery Saved Queries

21 days ago

BigQuery

Google has introduced an autosave feature for BigQuery saved queries that automatically saves changes to query text two seconds after typing stops. These changes are visible in the Version history as "Your changes" but do not create a new version until saved. Users can save a new version through the Google Cloud console. This feature enhances productivity while allowing users to control when changes are visible to collaborators.

Gemini Assistant Launches in BigQuery Data Canvas for Enhanced Data Analytics

1 months ago

Gemini BigQuery

You can now use a Gemini powered assistant in BigQuery data canvas, which can construct and modify canvases to answer analytics questions. This feature is in Preview. The chat assistant can create nodes, run queries, and make visualizations based on user prompts. You can add data and instructions for the assistant to follow. To use it, click Open Data Canvas Assistant, enter prompts, and manage data and settings through the assistant interface.

BigQuery ML Now Supports Llama and Mistral Models for Advanced Text Generation

1 months ago

BigQuery

Google has rolled out updates to BigQuery, enhancing data preparation, machine learning, and performance. Data preparation is now generally available, featuring AI suggestions for data cleansing and visual pipelines for workflow management. BigQuery ML supports remote models from Llama and Mistral AI for natural language tasks. Smart-tuning for materialized views improves performance and resource utilization for analytics workloads.

BigQuery Introduces Metadata Caching for SQL Translation

1 months ago

BigQuery

Google has introduced a preview feature for BigQuery that enables metadata caching for SQL translation, reducing latency for subsequent requests. Users can enhance translation quality by running interactive queries with configurations stored in YAML files in Cloud Storage, which may include SQL metadata, object mapping, DDL information, and schemas. Users can specify these configurations in the query editor. Cached metadata remains active for up to 7 days.

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?