Google Cloud Spanner Connection Configuration
  • 07 Dec 2022
  • 1 Minute to read
  • Dark
    Light

Google Cloud Spanner Connection Configuration

  • Dark
    Light

Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

summary

This is a help page for setting up connection information for Google Cloud Spanner.

Setting items

Item nameRequired
content
nameYesEnter the name of the connection information to be used inside TROCCO.
memorandumNoEnter a memo of the connection information used inside TROCCO.
JSON KeyYesEnter your service account (JSON Key) from Google Cloud Platform.
For details on how to get the service account (JSON Key), refer to How to Get the JSON Key.

How to get the JSON Key

When creating a new project

  1. Sign in to Google Cloud Platform. (You need a Google account here.) )

  2. Select the IAM and Managed Service Accounts item in the left bar.
    image.png

  3. Select Create service account and fill in the required information.

  4. Set permissions for the service account.

When using Google Cloud Spanner as a transfer source, you need access to read and query the database.

Select Cloud SpannerCloud Spanner Database Read from the role selections.

image.png

  1. Create a service account with Done.

  2. View the details of the service account you created.

Select the IAM and Management Service Accounts item in the left bar, and then select the service account you just created from the list of service accounts.

  1. Issue the JSON Key.

Select a key from the tabs at the top of the screen, select Add Key→ Create New Key→ Select JSON from Key Type, and select Create, and a JSON Key will be issued.

If you want to use an existing project

If you created a JSON Key when you created a service account in the past and the download file at that time remains, you can use it.

  1. Sign in to Google Cloud Platform. (You need a Google account here.) )

  2. Select the IAM and Managed Service Accounts item in the left bar.

image.png

  1. Select the service account you want to use.

Select the IAM and Management Service Accounts item in the left bar, and then select the service account you want to use from the list of service accounts.

  1. Issue the JSON Key.

Select a key from the tabs at the top of the screen, select Add Key→ Create New Key→ Select json from Key Type, and select Create, and a JSON Key will be issued.


Was this article helpful?