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 Platform 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 Platform Console IAM & Admin→Permissions page of your Cloud Dataprep project:

  • 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

This section shows you how to use the Google Cloud Platform Console to grant service account access to a BigQuery dataset owned by another project. See Assigning access controls to datasets for information on using the command line or APIs to grant access to datasets.

  1. Open the BigQuery UI and locate the dataset you wish to share with Cloud Dataprep. Click the drop down arrow next to the dataset’s name, then select Share dataset.

  2. Use the Add people field to add the compute and trifacta service accounts, then click Save changes.

  3. Open the Cloud Dataprep "Import Data" page, then select BigQuery from the left pane. By default, your current project is chosen in the breadcrumb bar. Select BigQuery to move up one level. Enter your GCP Console project ID in the Go to Project text box to view and select the dataset shared with Cloud Dataprep.

Removing service account access to a BigQuery dataset

  1. Open the BigQuery UI, click the drop down arrow next to the dataset’s name, select Share dataset.
  2. Click the "X" to the right of the compute and Trifacta service accounts to remove their access to the dataset.
Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation
Need help? Visit our support page.