I have already created this as an issue that’s been acknowledged (but not solved after nearly a year); however, just creating here to get full visibility of it as well.
## Problem you have encountered:
When using the execute authentication method of “Execute with user credentials of xxxx@xxxx.co.uk”, the permissions do not replicate the user’s access to BigQuery External Tables. I can definitely access and query the external table when I use BigQuery Console, or even when I click Run instead of Execute.
The error I get is: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials
Steps to reproduce:
Execute (“with user credentials”) a model that uses a BigQuery External Table to Google Drive.
Other information (workarounds you have tried, documentation consulted, etc):
The workaround I’m having to do whenever I run an external table model is to run it using the Dataform Service Account instead, which is a very annoying workaround given the default authentication is User Credentials.