Create Google Spanner Connection

Owned by Daniel Yanguas (Unlicensed)
Jun 30, 2024
2 min read

 

  1. Authentication Mode: OAuth

    image-20240630-023859.png

     

     

     

    Connection Properties:

Name

Mandatory

Description

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:

  1. There are two ways to create connection -

    1. Choose the Google Spanner connector from Pipeline tab > add connection.

      image-20240630-023827.png

       

       

       

    2. Go to the Connections tab > add connection > from the dropdown select Google Spanner.

       

       

  2. Fill up required fields.

  3. Choose the Authentication Type as OAuth

  4. Click Authorize

  5. You will be redirected to Google for oauth

  6. Select all the scopes and click continue

 

 

  1. Approve the request and you will be redirected to EazyDI

  2. Test connection to confirm

 

 

 

  1. Authentication Mode: Service Account
     

     

     

     

    Connection Properties:

Name

Mandatory

Description

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:

  1. There are two ways to create connection -

    1. Choose the Google Bigquery connector from Pipeline tab > add connection.

       

    2. Go to the Connections tab > add connection > from the dropdown select Google Spanner.

  2. Fill up required fields

  3. Choose the Authentication Type as Service Account

  4. Click Test Connection to check if valid

  5.  Click on create connection.

 

 

 

 

Â