CODEWITHSUNDEEP
google-bigquery
Uli Bethke
Uli Bethke

Reputation: 810

BigQuery Slot Usage and Billing across Projects

I have a question on how BigQuery handles slot allocation when running queries from one project that select data from tables in another project.

Let's assume the following scenario.

I have project A which is associated with billing account A I have project B which is associated with billing account B I have user C

User C has been granted permissions to query data in project A and project B.

User C logs on and selects project B from the dropdown at the top. User C then runs a query against project A

From which project will the resources/slots be allocated? Project A or project B? Which project will be billed? Project A or project B?

Upvotes: 1

Views: 2655

Answers (2)

Christopher
Christopher

Reputation: 941

Based on the documentation you will be billed under the billing attached to Project B and the slot usage will be in Project B as well. Regardless whether a view in project B is selecting from a table in project A as long as project B is the active project then you will be billed under the billing attached to project B.

BigQuery Pricing

Upvotes: 1

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173106

From which project will the resources/slots be allocated?

Project B

Which project will be billed?

Project B

Simple way of checking which project is/was "active" for specific query is to open Details Tab and check Job ID - the structure is project:location.id. So project part will tell you which project is/was active for the given query

Upvotes: 2

Related Questions