BigQuery - Google Drive Spreadhseet error

Hello,
My data are on a Google Spreadsheet.
The spreadsheet is connected to BigQuery and BigQuery to Metabase.

In Metabase I have this error : “Error while reading table: xxxx_metabase.xxxx_metabase_table, error message: Failed to read the spreadsheet. Errors: No OAuth token with Google Drive scope was found.”

Anyone could help me?

Thank you

Hi @jduprezen
Can you even run the query on BigQuery? I don’t think it has anything to do with Metabase.
It seems like you need to make some adjustments in BigQuery, so it knows the token for Drive:
https://stackoverflow.com/questions/49807276/bigquery-no-oauth-token-with-google-drive-scope-was-found

Dear flamber,
Thank you for your answer.
I can run query on BigQuery without any issue (even when I run the same query like the one I tried on Metabase).
But when I try with metabase I have the same error : “Error while reading table: xxxx_metabase.xxxx_metabase_table, error message: Failed to read the spreadsheet. Errors: No OAuth token with Google Drive scope was found.”

I don’t know why.
J

@jduprezen I don’t use BigQuery, but the error is coming from BigQuery, since Metabase doesn’t know anything about spreadsheets or Drive. Otherwise try using a different client and see if that triggers the same error.

Yes
Good idea

Thanks again

Still not working…

No one has the same issue ?

@jduprezen Did you try a different client?
If you search the forum, you’ll see that this is the first time someone posted this error.
But you’ll find a lot of posts, if you search the internet.

You need additional permission in yours service account to make queries to Google sheets through bq.


There is hidden link in db connection settings, that will generate different permission request. It just have no styling, but it’s a link