Skip to main content

Get permissions for BigQuery

Everything you need to use BigQuery as a source or as a destination

Written by Jonatan Gomes

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.

Did this answer your question?