---
schema_version: "1"
id: 4c6fcb8d3f19d9ef205c8e628d99b9e04fbd80403730975220efe68a47a03093
title: Create a Live Connection to Google BigQuery
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_direct_data_bigquery_create_connection.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_direct_data_bigquery_create_connection.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 54224269a8da84bedc02a44b7278e9bded14e06733d6a4c8d4b50563c93c58e9
description: Create a live connection to Google BigQuery warehouse to explore your data stored there.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Create a Live Connection to Google BigQuery

Create a live connection to Google BigQuery warehouse to explore your data stored there.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
      <colgroup>
        <col style="width:50%">
        <col style="width:50%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d111334e34">User Permissions Needed</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e34 ">To create live connections to Google BigQuery:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e34 ">Enable CRM Analytics Direct Data for external data sources</td>

        </tr>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e34 ">To explore data directly in Google BigQuery:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e34 ">Explore External Data Directly</td>

        </tr>
      </tbody>
    </table>

## Create the Live Connection

- In CRM Analytics, click the gear icon (![Gear icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_dataflowmanager_gear_icon.png)) and select **Data Manager**.
- Click **Manage Dataflows**.
- In the data manager, click the **Connect** tab.
- Click **Connect to Data**.
- Click **Live Connections**.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)
    
    Note If you don’t see the Live Connections tab, you need to [enable Direct Data in CRM Analytics](https://help.salesforce.com/articleView?id=analytics.bi_setup_direct_data_external_sources.htm&type=5&language=en_US) first.
- Click **Add Connection**.
- Click **Google BigQuery Direct Connector** and enter its settings, as described in the Connection Settings section.
- When done, click **Save** or **Save and Create Dataset**.

## Create Live Datasets for a Google BigQuery Source Table

After creating the live connection, create a live dataset that lets users explore Google BigQuery tables or views available with the connection.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note Live datasets are similar to CRM Analytics datasets, except that the data remains in an external data source.

After creating the live connection, enable a live dataset for the connection.

- In the data manager, click the **Data** tab.
- On the Live Datasets tab, click **Create Dataset**. Select the Google BigQuery connection and enable a Google BigQuery source table that is available with the connection.
- Name the live dataset and assign it to a CRM Analytics app. Use the app to control which Salesforce users, roles, and groups have access to explore Google BigQuery data with the connection.
- When done, click **Create Live Dataset**.

To begin exploring, click the live dataset from the Datasets tab in CRM Analytics Studio.

## Google BigQuery Live Connections Settings

All settings require a value, unless otherwise indicated. The service account that you use to connect to Google Big Query must have the standard role "BigQuery Data Viewer." Account creation generates a JSON file of account properties. Most of the necessary connection settings are in this file.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:33.33333333333333%">
          <col style="width:66.66666666666666%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d111334e203">Setting</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d111334e206">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e203 ">Connection Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e206 ">Identifies the live connection. Use a convention that lets you easily distinguish
              between different connections.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e203 ">Developer Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e206 ">API name for the connection. This name must be unique, begin with a letter, and can
              only contain underscores and alphanumeric characters. This name can’t include spaces, end
              with an underscore, or contain two consecutive underscores. You can’t change the developer
              name after you create the connection.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e203 ">Description</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e206 ">Description of the connection for internal use.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e203 ">Client Email</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e206 ">Enter the <code>client_email</code> value from the JSON
              file.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e203 ">Private Key</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e206 ">
              <p>Enter the <code>private_key</code> value from the JSON
                file.</p>
              <p style="margin-bottom:0;">Don’t include <code>"private_key": "-----BEGIN PRIVATE
          KEY-----"</code> at the start of the key and <code>\n-----END
          PRIVATE KEY-----\n"</code> at the end.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e203 ">Project ID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e206 ">
              <p>Enter the <code>project_id</code> value from the JSON
                file.</p>
              <p style="margin-bottom:0;">If you have multiple projects with the same service account, enter the ID of the
                project containing the live dataset that you want to create a connection to.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e203 ">Storage Path</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e206 ">
              <p>Optional setting. Path in Google Cloud Storage where a local stage file is created to
                store the data temporarily. Enter the bucket name or the bucket name and folder name. For
                example, enter <kbd>&lt;bucket_name&gt;</kbd> or
                <kbd>&lt;bucket_name&gt;/&lt;folder_name&gt;</kbd>.
              </p>
              <p style="margin-bottom:0;">To write files to this
                staging area, the user specified in Client Email must have the list, read, and write
                permissions on the bucket.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e203 ">Schema</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e206 ">
              <p>Google BigQuery schema whose data you want to explore with the connection. You can
                either add all the tables you want to explore to a single Google BigQuery schema or create a
                separate connection for each schema.</p>
              <p style="margin-bottom:0;">To keep data secure, we recommend creating a
                separate Google BigQuery schema specifically for Direct Data for Google
                BigQuery.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e203 ">Region ID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e206 ">Optional setting. Enter the data location of the live Google BigQuery dataset if the
              location isn’t in North America.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e203 ">Use Storage API</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d111334e206 ">Optional setting. If True, uses the Google BigQuery Storage Read API. See Google’s
              BigQuery Storage Read API. If False, uses Direct extract mode.</td>

          </tr>
        </tbody>
      </table>