Metabase connection with bigquery

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 :+1: 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.