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.

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

Open the BigQuery UI,
click the drop down arrow next to the dataset’s name, select
Share dataset.