---
schema_version: "1"
id: ab894721bd03dd4312cbaad663d892ad06c76162010a9eb6aeb4841aa900503f
title: Google Cloud Spanner Connection
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_connectors_googlecloudspanner_settings.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_googlecloudspanner_settings.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 9974a7c42b7ac22b67896dda1a52d51333ff1abf471886c08954c47a334e2688
description: Create a remote connection using the Google Spanner connector to sync data from Google Cloud Spanner to CRM Analytics.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Google Cloud Spanner Connection

Create a remote connection using the Google Spanner connector to sync data from Google Cloud Spanner to CRM Analytics.

## Connection Requirements

A Google Cloud Spanner connection requires a private key and client email. You can generate a JSON file containing this information from the IAM & Admin page in the Google Cloud Platform Console.

## Create Connection

1. On the Data Manager Connections tab, click **New Connection**.
2. Click the name of the connector, and click **Next**.
3. Enter the connector settings.
4. To validate your settings and attempt to connect to the source, click **Save & Test**. If the connection fails, CRM Analytics shows possible reasons.

All settings require a value, unless otherwise indicated.

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d162614e84 ">API name for the connection. This name can’t include spaces. The API name is
              used in your recipes to reference data extracted through this connection. You can’t
              change the developer name after you create the connection.</td>

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

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

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

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

          </tr>
          <tr class="">
            <td data-label="Connection Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d162614e81 ">Instance Id</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d162614e84 ">Enter the instance ID of the Google Cloud Spanner instance.</td>

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d162614e84 ">Enter the database ID of the Google Cloud Spanner database.</td>

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d162614e84 ">
              <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 dataset that you want to connect to.</p>
            </td>

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

## Connector Considerations

Keep these behaviors in mind when working with a Google Cloud Spanner connector.

- Connected object names must start with a letter and contain only letters, digits, or underscores. Object names can’t end with an underscore.
- Only field names with combinations of alphanumeric, dot, underscore, or dash characters are supported. If a connector includes field names that contain other characters, such as spaces or brackets, the sync fails.
- The connector can sync up to 20 million rows or 10 GB per object, whichever limit is reached first. When using the connector, Salesforce Government Cloud org data is protected in transit with advanced encryption and can sync up to 10 million rows or 5 GB for each connected object, whichever limit is reached first.

#### See Also

- [Google Cloud Spanner Connector Known Issues and Knowledge Articles](https://sfdc.co/gcsconnsearch)
- [Add and Remove Remote Objects and Fields from Data Sync](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_replicate_connection.htm&release=264.0.0&type=5 "Update data sync for connected external data sources to keep up with your changing business by adding objects, removing objects, and managing which fields are synced. Synced data is stored in CRM Analytics as objects that can be used in recipes.")