Data 360: How to Set Up a Data Share from Salesforce Data 360 to Google BigQuery

Prerequisites

Make sure you have access to the following:

• A Salesforce Data 360 org with permissions to manage Data Shares and Data Share Targets

• A Google Cloud Platform (GCP) project

• IAM admin privileges in GCP to assign required roles and manage service accounts

Step 1: Configure IAM Roles in Google Cloud Console

1. Navigate to the IAM tab in the Google Cloud Console.

2. Click “Grant Access”.

3. Add a new principal (email or group) and assign the following roles:

   • Analytics Hub Subscriber

   • Analytics Hub Viewer

   • BigQuery Admin

   • BigQuery Data Viewer

   • BigQuery Job User

Step 2: Create a Data Share Target in Data 360

1. In Salesforce Data 360, navigate to Data Share Targets tab.

2. Click New, and select Google BigQuery as the connection type.

3. Provide the following details:

   • Label: A display name (max 20 characters)

   • API Name: Auto-filled (can be customized)

   • Google Cloud Principal: Enter user or group email (must belong to a valid Google Workspace domain)

   • Type: Select either User or Group

4. Click Save. You’ll be redirected to the Google Sign-in page.

5. Authenticate using the provided Google Cloud Principal.

6. Once authenticated, you'll return to Data 360, and the Data Share Target will be marked Active.

Step 3: Create a Data Share in Data 360

1. Navigate to the Data Shares tab.

2. Click New and:

   • Provide a Label Name

   • Select the appropriate Data Space. Click Next

3. Choose the Objects you want to share. Save

Step 4: Link Data Share Target to the Data Share

1. From the Data Share record, click the “Link or Unlink Data Share Target” button (top-right corner).

2. Select the Google BigQuery data share target.

3. Click Save to complete the linking.

How to View Shared Data in BigQuery (Analytics Hub)

1. Go to BigQuery Studio in the Google Cloud Console.

2. In the left sidebar, navigate to: Sharing (Analytics Hub) > Search Listings

3. Use the search bar to search for the listing name based on the label used when creating the Data Share in Salesforce Data 360.

4. Click on the desired Listing to view details.

5. You’ll see the shared dataset/project name. Click Subscribe (if prompted) or navigate to the dataset directly from here.

How to Query the Shared Data in BigQuery:

1. In BigQuery Studio, expand the dataset under your project or the shared listing.

2. Select a table.

3. Use the Query Editor to write SQL queries, for example:

    
   SELECT * FROM 'shared_project.shared_dataset.shared_table_name' LIMIT 100;

4. Click Run to execute and view results.