Question

A retail analytics team stores a large customer transactions table in a BigQuery dataset called 'raw_finance'. A separate marketing team needs read access only to aggregated, non-PII summary data derived from that table. The finance team must retain full control of the underlying dataset and must not grant the marketing team any direct access to 'raw_finance'. What is the most appropriate way to design this data-sharing solution?

Accepted Answer

Create an authorized view in a separate dataset that queries the aggregated data, and grant the marketing team access only to the dataset containing the view.

Answer

Grant the marketing team the BigQuery Data Viewer role on the 'raw_finance' dataset and instruct them to query only the summary columns.

Answer

Export the aggregated results to a Cloud Storage bucket nightly and grant the marketing team read access to the bucket.

Answer

Copy the aggregated data into a new table inside 'raw_finance' and grant the marketing team access to that single table.