Luka Cempre | Swipe Insight

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

1 months ago

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 Now Supports GROUP BY and SELECT DISTINCT with Arrays and Structs

1 years ago

BigQuery

Google BigQuery has updated its SQL functionality to support GROUP BY and SELECT DISTINCT operations with arrays and structs, enhancing data analysis flexibility. Users can now group by entire struct fields in one operation and perform nuanced data deduplication across complex types. These improvements streamline queries and reduce complexity, particularly for grouping session traffic source fields.

BigQuery Introduces CHANGES Function for Tracking Table Modifications

1 years ago

BigQuery

Google has introduced the CHANGES function in BigQuery for enhanced data tracking. It allows users to return rows that have changed within a specified time range, supporting operations like INSERT, UPDATE, DELETE, and more. Users can specify timestamps to retrieve changes, with additional metadata provided. The table must have the change_history option enabled, and the function is limited to a 7-day time travel window and a maximum one-day range.

BigQuery Now Allows Default Storage Billing Configuration for New Datasets

1 years ago

BigQuery

BigQuery now allows setting a default storage billing dataset for new datasets at the organization or project level. Physical storage, billed based on physical bytes and including time travel, is cost-effective for highly compressible data, offering up to 90% savings, especially for datasets like Google Analytics 4 exports. Physical storage costs $0.04/$0.02 per GB per month, compared to logical storage at $0.02/$0.01. Regular monitoring is recommended for optimal billing setup.

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.

Google Delays Third-Party Cookie Deprecation in Chrome to 2025, Pending CMA Concerns

1 years ago

Tracking

Google has delayed the deprecation of third-party cookies in Chrome until early 2025, subject to resolving any remaining issues with the UK's Competition and Markets Authority (CMA).

Quantified LIKE Operator Now Available: Simplifies Multi-Pattern Queries

1 years ago

BigQuery

The quantified LIKE operator, now available, eases writing queries comparing a field value to multiple patterns. It uses three quantifiers: ANY, SOME, and ALL. ANY and SOME are true if one pattern matches the field value. ALL requires the field to match all patterns. For example, 'page_path LIKE "%blog%" AND page_path LIKE "%luka%"' becomes 'page_path LIKE ALL ("%blog%", "%luka%")'.