You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "ivan-toriya-precis (via GitHub)" <gi...@apache.org> on 2023/07/31 13:22:16 UTC

[GitHub] [airflow] ivan-toriya-precis commented on issue #32918: GCSToBigQueryOperator dataset access scope not working with a service account

ivan-toriya-precis commented on issue #32918:
URL: https://github.com/apache/airflow/issues/32918#issuecomment-1658364088

   Ah, sorry about that.
   
   The apache-airflow-providers-google was on 10.1.1 Updated just now to the latest 10.3.0, still the same error.
   
   ```sh
   Traceback (most recent call last):
     File "/opt/python3.8/lib/python3.8/site-packages/airflow/providers/google/cloud/transfers/gcs_to_bigquery.py", line 380, in execute
       job: BigQueryJob | UnknownJob = self._submit_job(self.hook, job_id)
     File "/opt/python3.8/lib/python3.8/site-packages/airflow/providers/google/cloud/transfers/gcs_to_bigquery.py", line 302, in _submit_job
       return hook.insert_job(
     File "/opt/python3.8/lib/python3.8/site-packages/airflow/providers/google/common/hooks/base_google.py", line 475, in inner_wrapper
       return func(self, *args, **kwargs)
     File "/opt/python3.8/lib/python3.8/site-packages/airflow/providers/google/cloud/hooks/bigquery.py", line 1599, in insert_job
       job_api_repr._begin()
     File "/opt/python3.8/lib/python3.8/site-packages/google/cloud/bigquery/job/base.py", line 693, in _begin
       api_response = client._call_api(
     File "/opt/python3.8/lib/python3.8/site-packages/google/cloud/bigquery/client.py", line 816, in _call_api
       return call()
     File "/opt/python3.8/lib/python3.8/site-packages/google/api_core/retry.py", line 349, in retry_wrapped_func
       return retry_target(
     File "/opt/python3.8/lib/python3.8/site-packages/google/api_core/retry.py", line 191, in retry_target
       return target()
     File "/opt/python3.8/lib/python3.8/site-packages/google/cloud/_http/__init__.py", line 494, in api_request
       raise exceptions.from_http_response(response)
   google.api_core.exceptions.Forbidden: 403 POST https://bigquery.googleapis.com/bigquery/v2/projects/project_id_Y/jobs?prettyPrint=false: Access Denied: Project project_id_Y: User does not have bigquery.jobs.create permission in project project_id_Y.
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org