Google Spanner

​

Add the Google Spanner Connector

​

Authenticate to Google Spanner

After you add the connector, you need to set the required properties.

• Instance Id: Enter the identifier (Id) of the instance to which you want to connect.
• Database: Enter the name of the database to which you want to connect.
• Project Id: Enter the project Id of the project where your instance resides.

supports authenticating to in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

• OAuth (default)
• OAuth JWT
• GCP Instance Account
• AWS Workload Identity
• Azure Workload Identity

​

OAuth

​

OAuth JWT

​

GCP Instance Account

​

AWS Workload Identity

​

Azure Workload Identity

​

Complete Your Connection

To complete your connection:

1. Specify the following properties:

• Database Dialect: Select the dialect type for the database. The default dialect is GoogleStandardSQL.
• (Optional) Database: Enter the name of the Google Spanner database to which you want to connect. If you leave this field blank, attempts to expose all databases in the instance as separate catalogs. If you want to access multiple databases, ensure that the following OAuth scopes are configured:
  • https://www.googleapis.com/auth/spanner.admin
  • https://www.googleapis.com/auth/spanner.data

2. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)
3. Connect to to connect to your account.
4. Click Create & Test to create your connection.

​

More Information