CODEWITHSUNDEEP
google-bigquerybigdatalimitquota
Runtime Error
Runtime Error

Reputation: 17

How to set a limit on data scanned by a user in Big Query

Is there a way to set a limit on a user to not query data of more than a particular size in a table.

Eg - If a user uses 'Select' command, he should be limited to query a certain amount of data irrespective of the query he writes.

I have been trying to follow this link - https://cloud.google.com/bigquery/quotas.

Upvotes: 0

Views: 1426

Answers (1)

David Morales
David Morales

Reputation: 670

You can set quotas at the project-level or at the user-level. Be careful though since it is not possible to assign a custom quota to a specific user or service account.

You can set quotas by following this steps in the cloud console:

  1. Go to quotas page
  2. Select only BigQuery service
  3. Look for Query usage per day per user or Query usage per day and select it
  4. Click on Edit Quotas
  5. Set the limit on the right side, validate and Submit

More information:

https://cloud.google.com/bigquery/docs/custom-quotas https://cloud.google.com/docs/quota#managing_your_quota_console

Upvotes: 0

Related Questions