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:
-
- Click the Connections icon (lightning bolt) on the top left menu.
- To create a connection, click New connection.
- Choose Google Cloud Spanner.
- Click Authenticate.
- In the Google account window, choose an existing Google account or click Add account to create a new Google account.
- In the next Google window click Allow to authorize Integrate.io ETL access.
- 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:
- Click the Connections icon (lightning bolt) on the top left menu.
- 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.
- 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.