CODEWITHSUNDEEP
google-bigquery
pompanoSlayer
pompanoSlayer

Reputation: 163

BigQuery: Is it possible it to have the query cost goes to the project owner?

I know if any user query data from a dataset, that person will get billed for the query, while the project will get billed for the storage. Is it possible to set it up so the project or billing account which creates the project get billed for the query instead of the person who did the query?

I guess one solution to this is to create a service account and have that service account does the querying through a web app.

Who is billed for BigQuery queries?

Upvotes: 0

Views: 1081

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173106

it is not the user per se who is being billed for querying data - it is rather project (from which query is being executed) get's billed. Of course if that given user happen to be a billing owner - it means that the user gets billed.
The only way I know to change this is:

  1. be added (as Project Viewer at least ) to the project that queryable data is in
  2. log into that project and execute query from within that project

Note if you are in Web UI - the active project becomes a billing project. and if you are using bq command line - you need to set default or billing project using respectve flag

Upvotes: 2

Related Questions