Contents x
    Google Cloud Spanner Connection Configuration
    • 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Contents

    Google Cloud Spanner Connection Configuration

    • Updated on 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    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 Spanner → Cloud 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?
    What's Next