Google BigQuery - schema was pulled down, but no data is available. error message: Failed to read the spreadsheet. Error code: PERMISSION_DENIED

Bug reports
1

Hello,

I am able to connect to Google BigQuery using the driver and it does populate the correct schema. However, no data is able to be browsed. There error message when attempting is "Error while reading table: xxxxxxxx, error message: Failed to read the spreadsheet. Error code: PERMISSION_DENIED.

The data source for BigQuery is a Google Sheets document, and it is able to be successfully queried from within BigQuery and other tools.

Thank you!

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.105 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "1.8.0_252-b09",
    "java.vendor": "Oracle Corporation",
    "java.vendor.url": "http://java.oracle.com/",
    "java.version": "1.8.0_252",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "25.252-b09",
    "os.name": "Linux",
    "os.version": "4.18.0-193.6.3.el8_2.x86_64",
    "user.language": "en",
    "user.timezone": "America/Detroit"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "sqlserver",
      "bigquery"
    ],
    "hosting-env": "unknown",
    "application-database": "h2",
    "application-database-details": {
      "database": {
        "name": "H2",
        "version": "1.4.197 (2018-03-18)"
      },
      "jdbc-driver": {
        "name": "H2 JDBC Driver",
        "version": "1.4.197 (2018-03-18)"
      }
    },
    "run-mode": "prod",
    "version": {
      "tag": "v0.36.3",
      "date": "2020-08-04",
      "branch": "release-0.36.x",
      "hash": "a792f14"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
2

Hi @jmcdole
There’s an issue open about that:
https://github.com/metabase/metabase/issues/13001 - upvote by clicking :+1: on the first post

3

Excellent – Thank you. I was not sure if the issues were the same.