BigQuery News & Updates for May 2025

Google Introduces Autosave Feature for BigQuery Saved Queries

3 hours ago

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

11 days 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

28 days 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.

Marketing Workflow Templates

Featured

Markifact offers ready-to-use marketing workflow templates to save time and automate digital marketing tasks. It is a no-code platform that enables users to create AI-powered workflows for automating decisions and actions across various marketing channels. Scale your marketing with agentic workflows, start using Markifact now for free!

Trending ️‍🔥

BigQuery Data Transfer Service adds Google Analytics 4 reporting support

1 months ago

Google Analytics BigQuery

BigQuery Data Transfer Service now supports Google Analytics 4 data, providing 12 daily partitioned tables that reflect UI reports. Each table includes views with _LATEST_DATE and _DATA_DATE fields. Pros include a simpler schema and modeled data, while cons involve lack of granular access and real-time export. Transfers are scheduled daily, with a refresh window of up to 30 days. Users must have viewer access in GA4 and create a BigQuery dataset for the transfer.

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

1 months ago

BigQuery

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

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

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

Google Enhances Gemini in BigQuery with Python Code Completion

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