`dataform run` raises `bigquery error: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.`

[ivan-toriya-precis]

I have table.sqlx

select *
from `project.dataset.external_gsheet_table`

When I run dataform run I get

bigquery error: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.

When I execute from the UI, everything works as expected.

Notes:

• Dataform SA has Editor access to the Google Sheet
• My gcloud authenticated account has access to the Google Sheet
• Could be related to #1869

[Ceridan]

Hi, thank you for reporting the issue. Does it work before for you in any of the previous Dataform Core versions, or is it a completely new action?

[ivan-toriya-precis]

I haven't tried it on a different version. I'm using 3.0.19

[bln4t0r]

@Ceridan - is there any additional information about this issue somewhere? I'm battling the same exact issue, and have tried both 3.0.19 and 3.0.22.

[shaunmb98]

I'm running into the same issues with dataform - never used to run into this

[rkgomezisa]

I have a similar issue with my personal account on Google Cloud. When using the ▶️Run button in the UI, it works. But when going to Start Execution > Actions, it doesn't (only with a service account). I have owner role in Google Cloud, Editor access in the Google Sheet and Sheet/Drive APIs are enabled on the project.

[ashish10alex]

UPDATE:

I tried running gcloud auth login --enable-gdrive-access --update-adc and it worked. I got this suggestion from this dbt FAQ.