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.