Question

Can I manage query costs? is there a way that i can set a limit for it in bigquery?

Answer 1

If you have multiple BigQuery projects and users, you can manage costs by requesting a custom quota that specifies a limit on the amount of query data processed per day.

Creating a custom quota on query data allows you to control costs at the project-level or at the user-level.

• Project-level custom quotas limit the aggregate usage of all users in that project.

• User-level custom quotas are separately applied to each user or service account within a project.