feat: Choose to run Using Service Account

[cbekker1]

**Please can there be a feature where you can run the pipeline using your service account. **

**On the web version of dataform you can run a script using you service account. This helps with access to google sheets based tables. At the moment I can't run or compile any scripts that have tables from google sheets in them in the IDE. Only the web IDE works because there you can select to run the script using your default service account.
**

[ashish10alex]

Hi @cbekker1 , thanks for raising the feature request. I believe you should be able to use the service account for regular tables / views creation provided you use the service account key and authenticate using dataform init-creds.

The Issue you are having with Google Sheets seems to be blocked by limitation in dataform cli. See dataform-co/dataform#1958 . I have not tried this myself @benjaminwestern has also raised dataform-co/dataform#1869 and could give more details.

[ashish10alex]

UPDATE:

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

[benjaminwestern]

Nice! that must just add the extra scopes into the OAuth flow... might have to go dig through the GCLOUD SDK to see if there are more golden nuggets like that