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.”
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.”
@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.
@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.
@alexshifrin
Post “Diagnostic Info” from Admin > Troubleshooting.
And since you haven’t provided the error message, then it’s even harder to know what you’re seeing.
If you’re using 0.36+ and setting up new connections, then you would have to manually make changes to the application database table metabase_database.details, so it would use the old OAuth method. Definitely not recommended to manually change that.
I would rather recommend reverting to a backup before 0.36 and using that until the issue is fixed (or the referenced issue).