This repository was archived by the owner on May 17, 2024. It is now read-only.
This repository was archived by the owner on May 17, 2024. It is now read-only.
The impersonate_service_account for oauth BigQuery method not working #693
Description
Describe the bug
The impersonate_service_account for oauth BigQuery method not working.
# profiles.yml my-profile: target: dev outputs: dev: type: bigquery method: oauth project: abc-123 dataset: my_dataset impersonate_service_account: dbt-runner@yourproject.iam.gserviceaccount.comI'm logged into account_a via gcloud auth login --update-adc which has Service Account Token Creator permission for dbt-runner@yourproject.iam.gserviceaccount.com. And it's working fine in day-to-day dbt usage. But when
$ data-diff --dbt 21:36:03 DEBUG Exception when trying to execute SQL code: dbt.py:265 SELECT column_name, data_type, 6 as datetime_precision, 38 as numeric_precision, 9 as numeric_scale FROM ``.``.INFORMATION_SCHEMA.COLUMNS WHERE table_name = '' AND table_schema = '' Got error: 403 POST https://bigquery.googleapis.com/bigquery/v2/projects/my-project/jobs?prettyPrint=false: Access Denied: Project my-project: User does not have bigquery.jobs.create permission in project my-project. Location: None Job ID: 42 New model or no access to prod table.Describe the environment
WSL Ubuntu 20.04.6 LTS
python version: 3.10.11
dbt version: 1.3.2
data-diff=0.8.4