Accessing Cross-Project BigQuery Datasets

By default, Cloud Dataprep can access data within the Google Cloud Platform project from which Cloud Dataprep is run. To give your Cloud Dataprep project access to a Google BigQuery dataset owned by a different Google Cloud console project, you must make the dataset accessible to the service accounts in your Cloud Dataprep project.

Finding your project's service accounts

Here are the Cloud Dataprep-related services accounts that you will find listed on the Google Cloud console IAM & Admin→Permissions page of your Cloud Dataprep project (click Include Google-provided role grants):

  • Google Compute Engine:
    project-number-compute@developer.gserviceaccount.com
  • Cloud Dataprep:
    service-project-number@trifacta-gcloud-prod.iam.gserviceaccount.com

Granting service account access to a BigQuery dataset

See Controlling access to a dataset to set up service account access to BigQuery datasets.