HowToFixMe
Google BigQuery

How to choose between on-demand and capacity-based pricing

By Sai Kiran Pandrala · Last verified: 2026-05-31 · Source: Google Cloud docs, Google Cloud Community, community Q&A

At a glance
ServiceGoogle BigQuery
CloudGoogle Cloud (GCP)
Guide typeProcedure
Skill levelIntermediate to advanced
Time15 - 60 minutes depending on account size

Running into How to choose between on-demand and capacity-based pricing on Google BigQuery is one of the more searched issues on Google Cloud Community and StackOverflow in the last 12 months. Here is what actually moves the needle when the Google Cloud docs are too generic.

What how to choose between on-demand and capacity-based pricing actually involves on Google BigQuery

Real-world context. Cost envelope: ~Rs 0 INR for the fix, support adds Rs 2,500 to Rs 80,000 INR per month (around $30 to $960 USD/month). Time at the keyboard: ~15 to 45 minutes. Time end-to-end including verification: ~1 to 4 hours including IAM review and validation. Have an Owner or relevant IAM role, gcloud CLI signed in, and a Cloud Logging filter ready staged before the first command so you do not stall on missing inputs.

This task on BigQuery is one of the more searched operational topics on AWS in the last 12 months. The procedure below is the path that works in a current AWS account with default IAM and standard VPC config.

The rest of this page is the structured fix path. Start with diagnose, then remediation, then the automation options so you do not have to do this by hand the next time it surfaces. Verify and safety sections at the end are the discipline that keeps the fix from regressing in production.

Diagnose first, fix second

Pull the Google Cloud request ID from the response headers: x-goog-request-id from response headers (or the insertId field in Cloud Logging for asynchronous calls). Google Cloud Support needs these IDs to look up your call in their internal logs - without them, the first reply on a ticket will ask you to reproduce the call and capture them. Save them with a timestamp; Google Cloud Support cannot retrieve calls older than 90 days for most services.

Check the Google Cloud Service Health at status.cloud.google.com and the per-product status board for ongoing service events in your region. About one in ten user-reported outages turn out to be region-scoped Google Cloud service degradation already being tracked. Cloud Service Health also exposes an API and Eventarc events, so you can wire a Lambda hook that pages on-call only when the failure correlates with an active Cloud Service Health event in the same region and service.

Reproduce the failure with the gcloud CLI in --debug mode. The full SigV4 request payload it emits, plus the exact endpoint URL it resolved to, is what Google Cloud Support uses to verify policy, region, or parameter issues without you having to share IAM credentials. Save the debug output to a file with gcloud ... --debug 2> debug.log and you can search it for the failed aws.request entry.

Solution-focused remediation path

If networking is suspect, use Network Intelligence Connectivity Tests. It is the only tool that simulates the full ENI-to-ENI path including firewall rules, hierarchical firewall policies, routes, and VPC Service Controls perimeters in one call. Manual trace is slower and misses transitive issues. The analyzer charges $0.10 per analysis - cheaper than a 30-minute call with your network team.

If quotas are suspect, the Quotas page in Cloud Console (IAM & Admin > Quotas) console shows current usage and the active limit side by side. Request increases through Quotas page in Cloud Console (IAM & Admin > Quotas), not through Support tickets - quota dashboard requests usually approve faster (often within minutes for soft limits) and they are auditable in Cloud Audit Logs. Set up Quotas page in Cloud Console (IAM & Admin > Quotas) + Cloud Monitoring alert policys at 80 percent usage so you get notified before you hit the wall.

When the fix involves a destructive operation (delete VPC endpoint, swap Cloud KMS key, rotate root credential), do it during a maintenance window with at least one teammate watching. Several Google BigQuery operations have implicit dependencies that only show up when traffic starts flowing again. Document the rollback path before you start, not during the incident.

Automate this fix so you do not do it twice

Add a Workflows or Cloud Tasks Automation runbook

For multi-step fixes that include a manual approval, use Workflows runbook. Document the fix as a runbook with workflows.executions.approve steps where a human signs off and workflows.steps.callApi steps where the runbook calls the Google Cloud API. Approvers are notified by SNS; the runbook execution shows up in Cloud Audit Logs with the approver's identity attached. This makes audit trails easy and stops production fixes from being one-person operations.

Wire the fix into Eventarc for self-healing

If the failure mode is recurring, automate the remediation instead of the diagnosis. Eventarc Scheduler or rules that watch Cloud Logging events for the specific error code can invoke a Lambda that runs the same fix you would run by hand. The Lambda must be idempotent (re-running it on already-healthy resources must be a no-op) and must emit a Cloud Monitoring metric so you can track how often the auto-fix fires. A spike in auto-fix invocations is itself a signal worth alerting on.

# Eventarc rule pattern (JSON)
{ "source": ["aws.google"], "detail-type": ["Google Cloud API Call via Cloud Audit Logs"], "detail": { "errorCode": ["AccessDenied", "ThrottlingException"] }
}

Automate the fix with Python and boto3

For anything you do more than twice, write a small Python script. The boto3 pattern below uses paginators (so it does not blow up on accounts with thousands of resources), explicit region binding, and a dry-run flag that defaults to True. Keep the script under 100 lines; if it grows beyond that, you are building a tool and should put it behind a Lambda with proper logging.

import boto3, sys
DRY_RUN = '--apply' not in sys.argv
client = boto3.client('google', region_name='us-east-1')
paginator = client.get_paginator('describe_...')
for page in paginator.paginate(): for item in page.get('Items', []): if item.get('Status') == 'FAILED': if DRY_RUN: print(f'[dry-run] would fix {item["Id"]}') else: client.modify_...(ResourceId=item['Id']) print(f'fixed {item["Id"]}')

Common pitfalls and what to watch for

The most common pitfall when fixing this on Google BigQuery is treating it as a one-off rather than as a recurring class of incident. The same misconfiguration tends to happen again after a deployment, a role rotation, or a region migration unless the fix is codified. Add a Org Policy or VPC Service Controls constraint, Organization Policy condition, or Org Policy or VPC Service Controls rule that prevents the same misconfig from being introduced again. Documentation alone does not survive turnover.

Another common trap: confirming the fix on a single resource and assuming the fleet is healthy. Loop your check across every account, region, and IAM principal that could exhibit the same symptom. If you cannot enumerate the affected scope without a script, you do not yet understand the scope.

Verify the fix worked

Safety, rollback, blast radius

FAQ

How long does how to choose between on-demand and capacity-based pricing typically take on Google Cloud?
For most Google BigQuery environments, 15 to 60 minutes including verification. Large multi-account setups, anything touching Org Policys at the Organizations level, or cross-region replication can stretch to half a day because Google Cloud has to wait for replication and IAM session caches.
Is there a rollback path?
Yes for most Google BigQuery changes. Export the existing config to JSON via gcloud google describe-... first, then commit it before you change anything. A few operations are one-way (Cloud KMS key deletion past the pending window, region migration, account closure). Check the Google Cloud doc for the specific API before you commit.
Will this affect dependent Google Cloud services?
Often yes. Google BigQuery resources are usually referenced by other workloads (Cloud Run services, GKE workloads, IAM-bound apps, Cloud CDN origins, downstream pipelines). Use IAM Access Analyzer + Cloud Audit Logs to enumerate consumers before changing a shared resource.
What if my Cloud Console layout does not match these steps?
Cloud Console UI moves quarterly. The Console layout in this page is current as of 2026-05-31 but the underlying CLI / SDK calls do not change as fast. If the Console version differs, fall back to aws CLI or SDK calls - those almost always still work.
Where do I get Google Cloud Support help if I am still stuck?
Open a case via the Google Cloud Support Center with: the request ID + correlation ID, the exact error string, Cloud Audit Log event, and your reproduction steps. Google Cloud Community is the no-cost public alternative - search there first; 80% of common Google BigQuery issues already have an answer with an Google-staff-verified flag.

References

Related guides worth a look while you sort this one out: