Create a workspace dataset, just like a workspace bucket
When researchers use BigQuery in Terra today, they can only interact with datasets in Cloud projects that are not Terra projects. Thus after issuing a query, researchers have a choice with results that they then want to access in Terra:
- Save to a CSV/JSON and write it to the workspace bucket
- Create another Cloud project outside of Terra, create a new dataset in the Cloud project, grant privileges to their Terra proxy group, and then save the results to a table in the new dataset
It would be really nice if we gave them a place to store query results as a table (instead of a file) within their Terra workspace.
Thanks Matt! I was wondering if there is any update with this feature request.
I want to have make connection between different notebooks. Saving the results as a table within the Terra workspace makes it much easier.
I have not seen any updates here. My recommended approach:
1- Create a Terra group with a name such as "<your-user-id>"
2- Add yourself to that group
3- Create a Cloud project outside of Terra
4- Create a new dataset in the Cloud project
5- Grant Editor privileges to the group "<your-user-id>@firecloud.org"
Then you can read/write the results to that dataset.
You don't have to create a separate group for this, you could user your "Proxy Group". However the proxy group identifier is of the form "PROXY_<some-long-number>@firecloud.org" which is not as user-friendly as creating your own Terra group.
Thanks for the solution.
Please sign in to leave a comment.