BigQuery News & Updates for August 2025

BigQuery Introduces New Vector Index Management and Data Loading Features

12 days ago

BigQuery introduces VECTOR_INDEX.STATISTICS to track data drift and ALTER VECTOR INDEX REBUILD for index maintenance, both in Preview. Access Transparency now covers BigQuery data prep in GA. New Preview options for CREATE EXTERNAL TABLE and LOAD DATA include null_markers for NULL strings and source_column_match for column mapping. MATCH_RECOGNIZE clause adds pattern recognition in SQL queries, enhancing analytical capabilities.

Top-Notch Google Ads Audit Tool

Featured

Effortlessly audit your Google Ads account with Marketing Auditor. Perform 200+ automated checks to uncover optimization opportunities and save over 10 hours per audit. Generate white-label reports in minutes with 50+ pages of actionable insights. Customize your reports with professional themes or your own branding, and export them in editable formats like PowerPoint or Google Slides. This tool is the ultimate solution for efficient and impactful Google Ads audits.

BigQuery launches DISTINCT pipe operator for selecting unique rows in queries

14 days ago

BigQuery

BigQuery now supports the DISTINCT pipe operator in pipe syntax queries, which returns distinct rows from an input table while preserving table aliases. It works like SELECT DISTINCT or UNION DISTINCT but can be used anywhere in the query. It computes distinct rows based on all visible columns, ignoring pseudo-columns, and does not expand value table fields. This feature is generally available.

BigQuery sets default on-demand query limit to 200TB per day from September 2025

19 days ago

BigQuery

BigQuery will implement a default on-demand usage limit of 200TB per day starting September 1, 2025. Existing unlimited projects will be set to 200TB or a custom limit based on recent peak usage. This aims to prevent runaway queries and cost overruns. Large users exceeding 200TB daily should update limits or consider other editions. Changes apply to on-demand usage quotas, with audit logs available for monitoring.

BigQuery Sharing Listings Can Now Be Monetized on Google Cloud Marketplace

20 days ago

BigQuery

You can commercialize BigQuery sharing listings on Google Cloud Marketplace using Analytics Hub. Publishers list data products with pricing and duration options, while subscribers find and use datasets. Required IAM roles and enabling the Analytics Hub API are needed. Listings link Sharing and Cloud Marketplace, creating linked datasets. Subscriptions are managed via Cloud Marketplace orders with standard pricing and revenue sharing.

Google Introduces Automated Data Insights Feature for BigQuery with Gemini Integration

1 months ago

BigQuery

Google launched an automated data insights feature for BigQuery with Gemini integration that creates natural language questions and SQL queries from metadata, helping analysts explore datasets efficiently. It reveals patterns, checks data quality, and aids analysis without starting from scratch. A Preview feature auto-generates table and column descriptions to improve documentation and discoverability.

BigQuery adds configuration settings and new data loading features

2 months ago

BigQuery

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 Enhances BigQuery with Continuous Queries and Cross-Regional Federated Queries

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

2 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

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