service account and dataset in different projects

[StevenSalazarM]

Hello,

thank you very much for the library, I agree it seems to be very promising!

Is it possible to add the project id as a parameter of the BigQueryClient?

Sometimes the project where the service account was created and the project of the dataset to be accessed may be different, for example in my case it fails due to the lack of the correct roles/permissions in the service account project, so the following piece of code of bqfetch.py fails:

          bq_client = bigquery.Client(
               credentials=credentials,
               project=credentials.project_id
           )

while using directly bigquery.Client():

bigquery.Client(credentials=credentials, project=bq_project_id)

works correctly.

Thank you,
Steven

[TristanBilot]

Hi,

Thanks for opening this issue!
This is a great idea, do not hesitate to open a pull request. Or tell me if you prefer let me do the modifications.

Cheers

[StevenSalazarM]

It would be easier for me if you can do the modifications 🙂

Thank you,
Steven