QuestionQ29

Data Management

Your organization has several datasets in BigQuery. The datasets must be shared with external partners so they can run SQL queries without copying the data into their own projects. You have organized every partner’s data in a separate BigQuery dataset. Each partner must be able to access only its own data. You want to share the data while following Google-recommended practices. What should you do?

Explanation

Analytics Hub, now part of BigQuery sharing, supports zero-copy cross-organization sharing through private listings. Publishing each partner-specific dataset as its own private listing and allowing only that partner to subscribe provides a read-only linked dataset for querying while maintaining per-partner access isolation.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!