CODEWITHSUNDEEP
google-cloud-platformgoogle-bigqueryquotagoogle-cloud-iam
Keisuke Nagakawa 永川 圭介
Keisuke Nagakawa 永川 圭介

Reputation: 1125

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.

Upvotes: 0

Views: 142

Answers (1)

guillaume blaquiere
guillaume blaquiere

Reputation: 75890

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.

Upvotes: 1

Related Questions