With Sheetgo, you can use BigQuery as a source to bring data from a database and use it in a Workflow. Alternatively, you can also use BigQuery as a destination to update information on a database without knowing any GoogleSQL.
But first, you need the correct permissions to work with a BigQuery database:
Read permissions enable BigQuery as a source.
Write permissions enable BigQuery as a destination.
These permissions must be granted by the system administrator of your Google Cloud account.
Important: permissions for the BigQuery database must be granted to the same email you use for Sheetgo.
Specific permissions your account may need
Your IT department or Google Cloud administrator may need to assign the following permissions to your account:
bigquery.config.get
bigquery.connections.list
bigquery.datasets.get
bigquery.datasets.getIamPolicy
bigquery.jobs.create
bigquery.models.list
bigquery.routines.list
bigquery.tables.get
bigquery.tables.getData
bigquery.tables.getIamPolicy
bigquery.tables.list
bigquery.transfers.get
bigquery.transfers.update
resourcemanager.projects.get
Read more about BigQuery permissions in the Google Cloud documentation.
