Accessing Cross-Project BigQuery Datasets

Stay organized with collections Save and categorize content based on your preferences.

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.