Create Google Spanner Connection
Authentication Mode: OAuth
Connection Properties:
Name | Mandatory | Description |
---|---|---|
Connection Name | Yes | Name of the connection |
Description | No | Description of connection |
Project ID | Yes | Your Google Project ID |
Database | Yes | Name of your Spanner database |
Instance ID | Yes | Name of your Spanner Instance |
Steps to create connection:
There are two ways to create connection -
Choose the Google Spanner connector from Pipeline tab > add connection.
Go to the Connections tab > add connection > from the dropdown select Google Spanner.
Fill up required fields.
Choose the Authentication Type as OAuth
Click Authorize
You will be redirected to Google for oauth
Select all the scopes and click continue
Approve the request and you will be redirected to EazyDI
Test connection to confirm
Authentication Mode: Service Account
Connection Properties:
Name | Mandatory | Description |
---|---|---|
Connection Name | Yes | Name of the connection |
Description | No | Description of connection |
Database | Yes | Your Spanner database |
Project ID | Yes | You Google Project’s ID |
Instance ID | Yes | Name of your Spanner Instance |
Client Email | Yes | Your Service Account’s Client Email |
Client ID | Yes | Your Service Account’s Client ID |
Private Key ID | Yes | Your Service Account’s Private Key ID |
Private Key | Yes | Your Service Account’s Private Key |
Steps to create connection:
There are two ways to create connection -
Choose the Google Bigquery connector from Pipeline tab > add connection.
Go to the Connections tab > add connection > from the dropdown select Google Spanner.
Fill up required fields
Choose the Authentication Type as Service Account
Click Test Connection to check if valid
Click on create connection.