Hello, I have the latest version of Metabase (0.38.1), and have connected it to Google BigQuery as described in the documentation in an attempt to connect to information stored in a Google Sheet. It is able to see the table, but when I try to ask a question on Metabase, it throws up the error “Access Denied: BigQuery BigQuery: Permission denied while globbing file pattern.” In the Data Model section of Metabase I can see all the columns, etc, but it seems like it can’t access the actual data. From previous posts, its seems that this is to do with an authentication problem with Google (since version 0.36, when service accounts started to be used), whereby the service account has access to BigQuery and not Google Sheets, but maybe I am mistaken and it is a different problem. I would like to know if a way around this problem has been found yet, or alternatively, if there is any reasonably easy way to connect Metabase to Google Sheets/Smartsheet/Excel Online or any similar service, as this was my original goal.
Thanks in advance for any ideas/news on the status of that problem.