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
}
}
}