Google Cloud Storage Bucket in BigQuery

1
votes

I'm trying to access a bucket on our Google Cloud Storage.

On my login details, I don't have permissions to open the bucket. How do I add another user to use on the gcloud console using a JSON token?

Screenshot for reference

I know the bucket was actually setup by Google. It's a data dump from DoubleClick. Want to pull the data down with BigQuery, but I can't see any of the datasets or run any queries against it with my current level of access.

Would this be something I can set myself using the token provided by Google or must I get hold of them again?

1
google-bigquerygoogle-cloud-storagedouble-click-advertising

1 Answers

1
votes

The bucket where Google dump the data transfer logs is owned by them. It's administrated through a private Google group, and they need to add your email (or service account email) for access. To get access to need to reach out to your Google DFP rep.

However, you should consider using the direct DFP data transfer service, instead of hand rolling your own DFP->GCS->BigQuery pipelines. Google will dump your DFP data transfer logs directly into BigQuery for you. So, there's no need to muck around with GCS.

https://cloud.google.com/bigquery/docs/transfer-service-overview