Allowing Integrate.io ETL access to my Google Cloud Spanner instance

Integrate.io ETL 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 Integrate.io ETL.

To create a Google Cloud Spanner connection In Integrate.io ETL:

    1. Click the Connections icon (lightning bolt) on the top left menu.
    2. To create a connection, click New connection. thumbnail image
    3. Choose Google Cloud Spanner.
    4. Click Authenticate.
    5. In the Google account window, choose an existing Google account or click Add account to create a new Google account.
    6. In the next Google window click Allow to authorize Integrate.io ETL access.
    7. In the new Google Cloud Spanner connection window, name the connection and enter the connection information:
      • Name - name for the new connection.
      • Project ID - copy from the Google Cloud Spanner console.
      • Instance ID - copy from the Google Cloud Spanner console.
      • Database - copy from the Google Cloud Spanner console.

Click Test connection to verify that the connection is valid and click Create connection.

To modify Google Cloud Spanner connections in Integrate.io ETL:

    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. 

thumbnail image

Enable Data Boost on Cloud Spanner connections in Integrate.io ETL:

Integrate.io ETL now supports the Data Boost feature on Google Cloud Spanner. This feature allows you to consume data from Cloud Spanner without having to share resource capacity. Follow these steps to enable it on your Spanner connection:

  1. Update the IAM permissions associated with your credentials (email used to authenticate) by following these steps:
    • Add the role: Cloud Spanner Database Reader (roles/spanner.databaseReader)
    • Add the permission: spanner.databases.useDataBoost
  2. Update your Spanner connection and check the "Enable Data Boost" option.

thumbnail image