I have a BigQuery table connected to a Google Sheet located in my google Drive. I can query the table on BigQuery but I can't access it with Metabase. I get this error message when trying:
Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.
I have added my service account email to the Google sheet as editor, but it still doesn't work. It seems like I need to add some additional rights to my service account but I can't figure out how to do it.
Could you please advise? Thanks!