Google BigQuery - Custom quota for each user

Question

Is there any way to set up a custom quota for each user?

Example:

• User1 = 10 Tb,
• User2 = 20 Tb
• User3 (Project owner) = unlimited

Answer 1

There is not a default feature to preform this, but it is possible to export your billing to another Big Query table and keep a track of each user consumption. A very good example of this excercise is shown by Mike Zinni. https://medium.com/google-cloud/visualize-gcp-billing-using-bigquery-and-data-studio-d3e695f90c08

With this feed Cloud Functions with a result of consumption and revoke a user.

This solution might have several hours of delay before revoking the permission.