When connecting to your own BigQuery your user account must have the following permissions:

  • storage.buckets.create
  • storage.objects.create
  • storage.objects.delete
  • bigquery.connections.list
  • bigquery.datasets.get
  • bigquery.jobs.create
  • bigquery.jobs.list
  • bigquery.models.list
  • bigquery.routines.list
  • bigquery.tables.get
  • bigquery.tables.getData
  • bigquery.tables.list
  • resourcemanager.projects.get
  • billing.viewer

How to add the Storage permission

(Note: This is used to load the data into BigQuery)

1. Sign in the Google Cloud Platform.

2. Select a Project then go to IAM page

3. Select the user that you are going to connect and edit their permissions by clicking the pen icon. Then on Edit permission, add the Storage Admin role, and click Save.