Search code examples
google-cloud-platformgoogle-bigqueryquotagoogle-cloud-iam

GCP BigQuery Quota: Exactly when will the quota be restricted?


I'm trying to restrict Query usage/day/user quota on GCP, and I have a question about this. Exactly when will the quota be limited?

Will the restriction be applied from the first query that exceeds the set quota, or will the restriction be applied before the query, which is estimated to exceed quota, is executed?

I've read throgh gcp's document on quotas but this situation is not documented.

Thank you.


Solution

  • The query can't be executed if it reach the quota limit. Let's say you have a quota to 10Gb per day per user

    • If you perform a request of 6Gb, ok, it works
    • If you perform another request of 6Gb, it fails
    • If you perform a new request of 3Gb, it works.