BigQuery News & Updates for June 2025

BigQuery adds configuration settings and new data loading features

13 days ago

Google BigQuery now allows admins to customize the BigQuery Studio interface for projects or organizations. It supports Spanner external datasets with enhanced security features. Data loading options include time zone and date/time formatting parameters in preview. A new Apache Spark demo notebook is available to demonstrate serverless Spark capabilities. These updates improve integration, flexibility, and user experience.

Google Ads Monthly Slides with AI Insights

Featured

Create professional Google Ads performance reports in Google Slides with AI insights and visualizations. Transform Google Ads data into polished presentations featuring AI-generated insights and custom visuals to impress stakeholders and streamline reporting. Use cases include reducing manual reporting time, presenting insights without design skills, maintaining reporting schedules, identifying trends, and sharing campaign insights for strategic decisions.

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

27 days ago

BigQuery

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

1 months 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

1 months 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.

BigQuery Introduces Enhanced SQL Group By Features for STRUCTs and ARRAYs

1 months 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

1 months 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

1 months 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

2 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 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?