BigQuery table backed by Google Sheet

[Prabeesh K.]

Hi,

How to we can read a BigQuery table that backed by google sheet?

For me, I am getting the following error.

"error": {
  "errors": [
   {
    "domain": "global",
    "reason": "accessDenied",
    "message": "Access Denied: BigQuery BigQuery: Permission denied while
globbing file pattern.",
    "locationType": "other",
    "location": "/gdrive/id/------------------"
   }
  ],
  "code": 403,
  "message": "Access Denied: BigQuery BigQuery: Permission denied while
globbing file pattern."
 }
}


Help to fix this issue.


Regards,
Prabeesh K.