BigQuery News & Updates for April 2025

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

7 days ago

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

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

Trending ️‍🔥

BigQuery Data Transfer Service adds Google Analytics 4 reporting support

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

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 Updates BigQuery with New Pipelines, Version Control, and Claude AI Integration

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

1 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

1 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 Enhances Resource Utilization Charts with New Metrics and Configuration Options

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

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