Hi Anil, Thank you for your attempt to answer the question. This is the broad answer.
The problem is we should add additional scope to Beam to read google sheet and add the permission to the service account to read the google sheet. Regards, Prabeesh K. On 4 May 2017 at 08:58, Anil Srinivas <[email protected]> wrote: > Hi, > The problem with it as what I see is that you don't have the permissions > to access the data in the BigQuery table. Make sure you login into the > account which has permissions for reading/writing data in the table. > > > > > Regards, > Anil > > > On Wed, May 3, 2017 at 6:21 PM, Prabeesh K. <[email protected]> wrote: > >> 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. >> >> >> >
