Has anyone dealt with this error before?
“There was an error running your query
Error: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.”
Me too, and the conclusion I reached was that Glide when send request to BigQuery, they only pass BigQuery API scope. However they should also request GoogleDrive scope.
Currently, there is no way to manually grant these permissions from Google Cloud Console.
A possible workaround is creating an intermediate table in BigQuery and querying that instead, but this is not a true solution for those needing real-time updates.
This is something that Glide needs to address to allow full integration.
I’ve gone ahead and changed this post to a Feature Request. This feature isn’t currently supported, but please add your vote to this post if you’re interested in seeing this considered for future development.
2 Likes