Knowledge base

Allowing Xplenty access to my Google Cloud Spanner instance

Xplenty can access your Google Cloud Spanner instance to both read data from it when you're moving data into a data warehouse for analysis, or write data into it if you're migrating data into Cloud Spanner. This article details creating the Google Cloud Spanner connection in Xplenty.

To create a Google Cloud Spanner connection In Xplenty:

    1. Click the Connections icon (lightning bolt) on the top left menu.
    2. To create a connection, click New connection

  1. Choose Google Cloud Spanner. 
  2. In the Google account window, choose an existing Google account or click Add account to create a new Google account.
  3. In the next Google window click Accept to authorize Xplenty access.
  4. In the new google cloud spanner connection window, copy the ids of your Google Cloud project, Cloud Spanner Instance ID and Database ID from your Cloud Spanner console. Name the connection, click Test connection to verify that the connection is valid and click Create google cloud spanner connection.

To modify Google Cloud Spanner connections in Xplenty:

    1. Click the Connections icon (lightning bolt) on the top left menu.
    2. Click a connection to open and modify it. Make any necessary changes, then click Reconnect, and Save changes. To exit the Google Cloud Spanner connection window without changes, click Back to connections (grey tab on the left side) on the Google Cloud Spanner connection window.
    3. To delete a Google Cloud Spanner connection, click on the three vertical dots on the far right of the connection listing and select the Delete connection option.