Community docs

BigQuery

Introduction

data.world connects to BigQuery via a Service Account associated with your project. Once you create a service account, create a key and download the associated JSON key file. The key file, and your service account email are required to configure a connection from data.world. Your account will need the roles BigQuery Data Viewer and BigQuery User in order to function properly.For additional information, see Google Cloud Platform documentation on predefined roles and permissions.

BigQuery Data Viewer

roles/bigquery.dataViewer

When applied to a dataset, dataViewer provides permissions to:

  • Read the dataset's metadata and to list tables in the dataset.

  • Read data and metadata from the dataset's tables.

When applied at the project or organization level, this role can also enumerateall datasets in the project. Additional roles, however, are necessary to allowthe running of jobs.

Permissions

bigquery.datasets.get
bigquery.datasets.getIamPolicy
bigquery.models.getData
bigquery.models.getMetadata
bigquery.models.list
bigquery.routines.get
bigquery.routines.list
bigquery.tables.export
bigquery.tables.get
bigquery.tables.getData
bigquery.tables.list
resourcemanager.projects.get
resourcemanager.projects.list

BigQuery User

roles/bigquery.user

Provides permissions to run jobs, including queries, within the project. The user role can enumerate their own jobs, cancel their own jobs, and enumeratedatasets within a project. Additionally, allows the creation of new datasetswithin the project; the creator is granted the bigquery.data Owner role for these new datasets.

Permissions

bigquery.bireservations.get
bigquery.capacityCommitments.get
bigquery.capacityCommitments.list
bigquery.config.get
bigquery.datasets.create
bigquery.datasets.get
bigquery.datasets.getIamPolicy
bigquery.jobs.create
bigquery.jobs.list
bigquery.models.list
bigquery.readsessions.*
bigquery.reservationAssignments.list
bigquery.reservationAssignments.search
bigquery.reservations.get
bigquery.reservations.list
bigquery.routines.list
bigquery.savedqueries.get
bigquery.savedqueries.list
bigquery.tables.list
bigquery.transfers.get
resourcemanager.projects.get
resourcemanager.projects.list