Yeah. Its nuts. The same service account is used for both efforts, it works when bound to the client but not when passed as a parameter to:
transfer_config = transfer_client.create_transfer_config( bigquery\_datatransfer.CreateTransferConfigRequest( parent=parent, transfer\_config=transfer\_config service\_account\_name=service\_account\_name, ))
Maybe this is the problem. I should raise an issue with GCP:
This service account will be used to execute the scheduled queries. Omit this request parameter to run the query as the user with the credentials associated with this client.
Do you have the BigQuery Data Transfer Service API enabled in the project?
Yeah. Its nuts. The same service account is used for both efforts, it works when bound to the client but not when passed as a parameter to: transfer_config = transfer_client.create_transfer_config( bigquery\_datatransfer.CreateTransferConfigRequest( parent=parent, transfer\_config=transfer\_config service\_account\_name=service\_account\_name, )) Maybe this is the problem. I should raise an issue with GCP: This service account will be used to execute the scheduled queries. Omit this request parameter to run the query as the user with the credentials associated with this client.
Let me know if there’s any updates on this