Exploring architecture patterns
This section presents three architecture patterns for organizing BigQuery resources. The following three patterns should cover most of the common usage patterns for teams and organizations using BigQuery. It is important to understand these architecture patterns to determine what setup in BigQuery will work best for your usage. Each pattern has its advantages and most organizations combine elements of multiple patterns. We will lead with the recommended design and outline alternative approaches, including the considerations for each one:
- Centralized enterprise data warehouse: The BI and data team owns all department or business unit data. Departments have their own projects with views and dashboards for utilizing the organization’s enterprise data warehouse.
- Decentralized enterprise data warehouse: Each department owns its raw data. The organization creates a central data warehouse project for analysis.
- Cross-org data exchange...
