Question

A retail analytics company wants to monetize a curated BigQuery dataset by sharing it with dozens of external partner organizations. Requirements: partners must query the data from their own projects (paying for their own compute), the provider must be able to revoke access and publish updates centrally without copying data to each partner, and the provider must track which organizations have subscribed. Which approach best meets these requirements?

Accepted Answer

Publish the dataset as a listing in an Analytics Hub data exchange; partners subscribe to create linked datasets in their own projects.

Answer

Create authorized views over the dataset and grant each partner's service account the BigQuery Data Viewer role on the view.

Answer

Export the dataset to Cloud Storage as Avro files and share signed URLs with each partner organization.

Answer

Schedule a BigQuery data transfer to copy the dataset into each partner's project on a nightly basis.