Question

A retail company stores its historical sales data in BigQuery. The marketing analytics team needs to run their own exploratory queries against this data without copying it, and the finance team wants to query the same tables independently. Leadership wants a solution that keeps a single authoritative copy of the data while enabling multiple teams to analyze it concurrently. Which approach best supports making this data useful and accessible across teams?

Accepted Answer

Grant each team read access to the shared BigQuery dataset so they can query the same authoritative tables directly.

Answer

Export the sales tables to CSV files and email them to each team so they can load the data into their own tools.

Answer

Create a separate full copy of the dataset for every team to prevent them from interfering with each other's queries.

Answer

Move the sales data into a Cloud SQL database and have each team connect through a shared application server.