Contents x
    Points to note when referencing BigQuery tables generated from SpreadSheets
    • 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Contents

    Points to note when referencing BigQuery tables generated from SpreadSheets

    • 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

    The BigQuery table generated from Google Spreadsheets must be referenced in the connection information using a service account that has been granted appropriate privileges.

    BigQuery tables generated from Google Spreadsheets cannot be referenced in OAuth authenticated connection information.
    It is necessary to refer to the connection information using a service account that has been granted appropriate permissions.

    1. Create a service account for BigQuery.
      * Please refer to here for necessary permission information.

    2. Add the service account's email address to the target SpreadSheet sharing settings.

    3. Click here to move to the BigQuery connection information creation screen from trocco and create it using a service account (JSON key).

    image.png

    1. Follow the on-screen instructions to enter the required information and click Save.

    image.png

    If you have any other questions or concerns about using the service, please contact the troccoCS staff.

    Was this article helpful?
    What's Next