Skip to main content

Cost Limits

It's easy to overspend on BigQuery, so we implemented several features to prevent accidental expensive queries.

Query Limits​

Set a per-query byte limit in the editor's configuration panel. If a query exceeds your limit, a warning appears before execution.

Query Limit Config

Default: 100 GB (configurable in Settings)

Query Limit Warning

The warning modal offers:

  • Cancel: Return to editor
  • Run Once: Execute without changing limit
  • Update Once: Use new limit for this query only
  • Update Permanently: Save new limit for all future queries

This "run once" option reduces friction when you occasionally need to exceed small limits.

Budgets​

Set spending budgets in Settings > Cost Management. Budgets can be daily, weekly, or monthly, and apply to individual users or all organization members.

Budget Limits Settings

Scope​

These limits apply only to queries run within Querylab.io. Scheduled queries and queries run outside the app are not affected.