[Feature Request]: Provide option in ReadFromBigQuery to set project from which queries are executed/billed

[kisssam]

What would you like to happen?

The ReadFromBigQuery method should provide an option to set the query execution project:

• similar to the load_job_project_id parameter in WriteToBigQuery in the Python SDK.
• similar to the bigQueryProject parameter in the Java SDK .

Currently, the project is inferred from the project running the pipeline or the project which contains the temporary dataset, if the temp dataset is set.

Issue Priority

Priority: 2 (default / most feature requests should be filed as P2)

Issue Components

• [X] Component: Python SDK
• [ ] Component: Java SDK
• [ ] Component: Go SDK
• [ ] Component: Typescript SDK
• [ ] Component: IO connector
• [ ] Component: Beam examples
• [ ] Component: Beam playground
• [ ] Component: Beam katas
• [ ] Component: Website
• [ ] Component: Spark Runner
• [ ] Component: Flink Runner
• [ ] Component: Samza Runner
• [ ] Component: Twister2 Runner
• [ ] Component: Hazelcast Jet Runner
• [X] Component: Google Cloud Dataflow Runner

[TSultanov]

It seems that we need a similar functionality to support ReadFromBigQuery transform for Python examples in Playground.

Our examples need to read the sample data from a different GCP project (clouddataflow-readonly), but use our GCP project for running the job, as we cannot give any permissions for our service account to create jobs in the clouddataflow-readonly one.

This already works in Java (https://play-dev.beam.apache.org/?path=SDK_JAVA_MinimalBigQueryTornadoes&sdk=java).