google-cloud-platform - 无法将 Google Ads 连接到 BigQuery

Question

我刚开始使用 GCP，无法从广告创建数据传输。我按 this documentation 完成了所有步骤但我总是在没有任何解释的情况下遇到问题。

There was a problem saving this transfer config
This transfer config could not be saved. Please try again.
iq

有时这两个字母会变，据我记得是'jk'

Answer 1

据我了解，您无法使用控制台创建从 Google Ads 到 BigQuery 的数据传输。

根据 documentation，此错误可能是因为您不具备所有必要的权限而引起的:

• BigQuery Data Transfer Service:

bigquery.transfers.update permissions to create the transfer Bothbigquery.datasets.get and bigquery.datasets.update permissions on thetarget dataset The bigquery.admin predefined IAM role includesbigquery.transfers.update, bigquery.datasets.update andbigquery.datasets.get permissions. For more information on IAM rolesin BigQuery Data Transfer Service, see Access control reference.

• Google Ads: Read access to the Google Ads Customer ID or manageraccount (MCC) that is used in the transfer configuration.

此外，您可以使用 bq command 设置传输,

bq mk \
--transfer_config \
--project_id=project_id \
--target_dataset=dataset \
--display_name=name \
--params='parameters' \
--data_source=data_source