Google BigQuery

This section provides a description of the script components for Cloud > Google BigQuery.

Cloud IAM permissions

When you use Google Cloud Platform connectors, appropriate permissions are required for each account that is used to connect to a Google Cloud Platform service.

The Cloud IAM permissions necessary for the Google BigQuery connector are as follows:

Load table data

Permission	Remarks
bigquery.jobs.create
bigquery.tables.create
bigquery.tables.get
bigquery.tables.update
bigquery.tables.updateData
storage.objects.get
storage.buckets.list	This permission is necessary to execute Update the list of bucket names.
storage.objects.list	This permission is necessary to execute Refresh folder path list and Refresh file list.
resourcemanager.projects.get	This permission is necessary to execute Update the list of destination project IDs.
bigquery.datasets.get	This permission is necessary to execute Update the list of destination dataset names.
bigquery.tables.list	This permission is necessary to execute Update the list of destination table names.

Extract table data

Permission	Remarks
bigquery.jobs.create
bigquery.tables.export
storage.objects.create
storage.objects.delete
storage.objects.get
resourcemanager.projects.get	This permission is necessary to execute Update the list of project IDs.
bigquery.datasets.get	This permission is necessary to execute Update the list of dataset names.
bigquery.tables.list	This permission is necessary to execute Update the list of table names.
storage.buckets.list	This permission is necessary to execute Update the list of destination bucket names.
storage.objects.list	This permission is necessary to execute Update the list of destination folder paths.

Execute Select SQL

Permission	Remarks
bigquery.jobs.create
bigquery.tables.create
bigquery.tables.getData
bigquery.tables.updateData
resourcemanager.projects.get	This permission is necessary to execute Update the list of project IDs.
bigquery.datasets.get	This permission is necessary to execute Update the list of dataset names of the save destination.
bigquery.tables.list	This permission is necessary to execute Update the list of table names of the save destination.

Refer to the descriptions on each page from the links below.