Hi, im having a difficulty to connect my database from bigquery. Its already connect but seems metabase cannot read the data. its show Access Denied: BigQuery BigQuery: No OAuth token with Google Drive scope was found.
Please advice. Thanks
Hi, im having a difficulty to connect my database from bigquery. Its already connect but seems metabase cannot read the data. its show Access Denied: BigQuery BigQuery: No OAuth token with Google Drive scope was found.
Please advice. Thanks
Hi @gorbymatheus
Currently Service Accounts doesn’t allow reading Google Drive:
https://github.com/metabase/metabase/issues/13001 - upvote by clicking on the first post
Hi @flamber thanks for the feedback. is there any tools or solutions that we can link our google sheet as a datasource to metabase? thanks
@gorbymatheus
The only hacky workaround is to copy the metabase_database.details
from an existing OAuth database to the one using Service Account, and then it will allow switching between the two types of authentication.
Remember to backup application database before upgrade/downgrade or any manual changes.