- 07 Dec 2022
Points to note when referencing BigQuery tables generated from SpreadSheets
- Updated on 07 Dec 2022
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.
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.
Create a service account for BigQuery.
* Please refer to here for necessary permission information.
Add the service account's email address to the target SpreadSheet sharing settings.
Click here to move to the BigQuery connection information creation screen from trocco and create it using a service account (JSON key).
- Follow the on-screen instructions to enter the required information and click Save.
If you have any other questions or concerns about using the service, please contact the troccoCS staff.