Google Spanner
Google Spanner
Setup Guide
Follow these steps to connect Google Spanner to your CData Connect account:
-
Open the Connections page of the CData Connect dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type Google Spanner into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Select a Database Dialect. This is the dialect type of the connected database. The default value is correct for most connections.
-
Select an Auth Scheme and follow the relevant instructions below.
Authentication Methods
OAuth
-
Enter the following information:
-
Project Id—the ID of the project where your Google Spanner instance resides.
-
Database—the name of the database.
-
Instance Id—the ID of the Google Spanner instance to which you are connecting.
-
-
Click Sign in with Google to connect securely through OAuth. This action opens the Google Spanner sign-in page on a new tab.
-
Log into your Google Spanner account.
-
At the top of the CData Connect Add Google Spanner Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
OAuthJWT
-
Enter the following information:
-
OAuthJWT Cert—the content of the JSON certificate provided by Google.
-
OAuthJWT Subject—(optional) a subject value is required if the service account is part of a GSuite domain and you want to enable delegation.
-
Project Id—the ID of the project where your Google Spanner instance resides.
-
Database—the name of the database.
-
Instance Id—the ID of the Google Spanner instance to which you are connecting.
-
-
At the top of the CData Connect Add Google Spanner Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect and Google Spanner, see this information page.