CODEWITHSUNDEEP
google-bigquery
김범철
김범철

Reputation: 19

bigQuery Google Cloud how to share table with other users?

I currently have a gcp account and are investigating permissions for the big query. I wonder if I can share the table with other users.

I read the related documents but could not find the answer. (cloud.google.com/bigquery/docs )

Upvotes: 0

Views: 4303

Answers (2)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172994

In BigQuery you can set access on dataset level as a lowest. Tables and views are child resources of datasets and they inherit permissions from their respective parent dataset. See more at Access Control

If you want user to have access to specific table in dataset - the workaround is to use so called authorized views

So, you can create view on top of table of interest - you put this view to the dataset that the user has already access to - then you give that view access to dataset where you have your table of interest. you are done now. User has access to the table via view but at the same time user does not have access to the dataset where this table is ...

see more on Creating an Authorized View in BigQuery

Upvotes: 1

Felipe Hoffa
Felipe Hoffa

Reputation: 59175

In the classic UI (https://bigquery.cloud.google.com):

enter image description here

Also with the API: https://cloud.google.com/bigquery/docs/reference/rest/v2/datasets/update

Upvotes: 1

Related Questions