You can access Data 360 objects as datasets in Google BigQuery by creating a data share. Zero copy integration allows data to be directly shared and queried without copying it into Google BigQuery. When data is accessible in Google BigQuery, you can work with harmonized and unified data from Data 360. Sharing data involves these high-level steps.
Before you begin:
- Review Supported Regions for Google BigQuery Integration.
- If you use VPC Service Controls and if the Analytics Hub API is restricted, then create an egress rule in the VPC Service Controls Perimeter to include the Salesforce Analytics Hub Producer project. For more information, see Analytics Hub VPC Service Controls rules.
- Identify the Data 360 objects that you want to access.
-
Create a data share in Data 360.
See Create a Data Share.
- Establish connectivity with Google BigQuery by creating a data share target in Data 360.
- Link the data share with the data share target to make the Data 360 objects accessible in BigQuery.
- In Google BigQuery subscribe to the Data 360 data shares using the Analytics hub.
- Create a Data Share Target to Connect with Google BigQuery
To establish connectivity with a Google BigQuery account, create a data share target in Data 360. - Subscribe to Data Shares in Google Analytics Hub
The Google Cloud users can subscribe to the data using the Analytics Hub. - Supported Regions for Google BigQuery Integration
Data Cloud supports cross-cloud data sharing with Google BigQuery. In cross-cloud data sharing, Google BigQuery can be in any location where data sharing is available.