CODEWITHSUNDEEP
google-bigquery
Ryan
Ryan

Reputation: 73

How do I share a bigquery dataset with another project?

How do I share a bigquery table/dataset with another project? I do not see an option to share with a specific project.

Upvotes: 5

Views: 12603

Answers (1)

Jeremy Condit
Jeremy Condit

Reputation: 7046

You can't share a dataset with a project. You can share a dataset with a user, a group, or a view, and you can also make a dataset completely public.

If you'd like to share with the users who have access to another project, the best solution is probably to create a Google group (http://groups.google.com), share your dataset with that group, and add that group to project #2. Then you can use membership in the group to control access to both the dataset and the other project.

Once you've shared data with another project, members of that project will probably want to select "Project menu > Switch to project > Display project..." and enter the ID of the other project in order to display those datasets in the web UI's navigation bar.

And since I mentioned it, if you share with a view, you will give access to any user who can query the view, regardless of whether they can access the underlying data.

Upvotes: 10

Related Questions