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

July 17, 2025 at 4:04:03 AM

TL;DR 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 sets default on-demand query limit to 200TB per day from September 2025

Starting September 1, 2025, BigQuery will implement a default on-demand usage limit of 200TB per day for all projects. Existing projects currently set to "unlimited" will be adjusted to a custom limit based on their peak usage over the past 30 days, with added headroom for growth. Projects that already have a limit in place will remain unchanged.

Purpose of the Change

This update aims to prevent accidental runaway queries and reduce the risk of access exploitation, helping users manage costs and avoid unexpected overruns under the on-demand compute pricing model.

Key Details

  • Quota changes: The quotas for QueryUsagePerDay and QueryUsagePerUserPerDay will now apply only to on-demand usage.
  • New projects: All projects created after the effective date will have a default daily query usage limit of 200 TiB.
  • Existing projects: Those with unlimited quotas will be assigned custom limits based on recent peak usage.
  • Monitoring: Customers can track these changes via Logs Explorer, requiring the roles/logging.viewer IAM role.

Recommendations

Large users who expect to run queries exceeding 200TB per day (costing approximately $1,250) should proactively update their limits and consider appropriate BigQuery editions to fit their workload needs.

Have more questions on this topic? Ask our AI assistant for in-depth insights.

The Only Digital Marketing Feed You'll Ever Need.

Stay informed your way. Tailored updates when and how you want them. 100% Free.

10,000+ Users

500+ Sources

1000+ Tools

Or

Related Posts

Google unveils Conversational Analytics API to chat with data anywhere

Google unveils Conversational Analytics API to chat with data anywhere

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
BigQuery Data Transfer Service adopts consumption-based pricing for third-party connectors

BigQuery Data Transfer Service adopts consumption-based pricing for third-party connectors

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
BigQuery Reference Panel Adds Schema Preview and Query Editing Features

BigQuery Reference Panel Adds Schema Preview and Query Editing Features

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Top-Notch Google Ads Audit Tool

Top-Notch Google Ads Audit Tool

Featured
BigQuery adds Gemini-powered data aggregation in Preview for easier data prep

BigQuery adds Gemini-powered data aggregation in Preview for easier data prep

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
BigQuery adds WITH expressions for temporary variables in GoogleSQL queries

BigQuery adds WITH expressions for temporary variables in GoogleSQL queries

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
BigQuery Update Enabling advanced runtime with short query optimizations in preview

BigQuery Update Enabling advanced runtime with short query optimizations in preview

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
BigQuery Introduces New Vector Index Management and Data Loading Features

BigQuery Introduces New Vector Index Management and Data Loading Features

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source

Related Tools

Markifact logo

Markifact

Verified Tool

Verified Tool

Markifact is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Marketing Workflows Powered by AI

Featured
Marketing Auditor logo

Marketing Auditor

Verified Tool

Verified Tool

Marketing Auditor is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Automated audits for Google Ads and Analytics.

Get Featured Here

Showcase your tool in this list.

Contact Us
Databricks logo

Databricks

Generative AI-powered data intelligence platform

Data Engineering
GA4 SQL logo

GA4 SQL

Verified Tool

Verified Tool

GA4 SQL is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Generate GA4 BigQuery queries easily

Data Analysis
TapClicks logo

TapClicks

Automated marketing solutions powered by your data

Data Engineering
Stitch logo

Stitch

Automated cloud data pipelines, no coding needed

Data Engineering
Akkio logo

Akkio

AI-powered analytics for agencies

Data Analysis
NinjaCat logo

NinjaCat

AI-powered marketing data and analytics platform

Reporting
Funnel logo

Funnel

Aggregate and analyze marketing data seamlessly

Reporting
Fivetran logo

Fivetran

Effortlessly centralize and move data from any source

Data Engineering

Get Featured Here

Showcase your tool in this list.

Contact Us