This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Control access to query BQ tables from specific project

Posted on 11-22-2023 11:49 PM
meln
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hi all,

So we have 2 GCP project, let's call them `real` and `playground`. There are BQ tables under both, and if someone has access to both projects he/she should be able to see tables under both projects on BQ (assume no dataset or table restrictions).

Now I want to avoid the scenario of someone (intentionally or accidentally) querying a table in `real` and uploading that results into `playground`, because there are users in `playground` who should not have the ability to see any data in `real`. That person querying from `real` should ideally be using the `real` GCP project, and can only upload any results within `real`.

Is this possible in BigQuery?

0 5 1,649
Topic Labels
0 Likes
5 REPLIES 5
Top Solution Authors
View all