Loading
Feature degradation | Gmail Email delivery failureRead More
Salesforce Data Pipelines
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Google Cloud Spanner Connection

            You are here:

            1. Salesforce Help
            2. Docs
            3. Salesforce Data Pipelines

            Google Cloud Spanner Connection

            Create a remote connection using the Google Spanner connector to sync data from Google Cloud Spanner to Salesforce Data Pipelines.

            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, Salesforce Data Pipelines shows possible reasons.

            All settings require a value, unless otherwise indicated.

            Connection Setting Description
            Connection Name Identifies the connections. Use a convention that lets you easily distinguish between different connections.
            Developer Name 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.
            Description Description of the connection for internal use.
            Private Key Enter the private_key value from the JSON file.
            Instance Id Enter the instance ID of the Google Cloud Spanner instance.
            Database Enter the database ID of the Google Cloud Spanner database.
            Client Email Enter the client_email value from the JSON file.
            Project ID

            Enter the project_id value from the JSON file.

            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.

            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.
             
            Loading
            Salesforce Help | Article