Hi, while I am trying to query the table that is backed by google sheet in beam python sdk getting following error. error(s): errorResult: Using table <table_name> is not allowed for this operation because of its type. Try using a different table that is of type TABLE., error: Using table <table_name> is not allowed for this operation because of its type. Try using a different table that is of type TABLE.
Anybody help to fix this issue. Regards, Parbeesh K. On 5 May 2017 at 13:05, Prabeesh K. <[email protected]> wrote: > Hi Davor, > > Thank for your prompt reply. > > Regards, > Prabeesh K. > > On 5 May 2017 at 05:48, Davor Bonaci <[email protected]> wrote: > >> This sounds like a Dataflow-specific question, so it might be better >> addressed by a StackOverflow question tagged with google-cloud-dataflow [1]. >> >> I'd suggest checking the Dataflow documentation for more information >> about its security model [2]. You'd likely have to use a service account, >> as described there for a few scenarios. >> >> Hope this helps, but please don't hesitate to post on StackOverflow for >> any Dataflow-specific questions. >> >> Davor >> >> [1] http://stackoverflow.com/questions/tagged/google-cloud-dataflow >> [2] https://cloud.google.com/dataflow/security-and-permissions >> >> On Wed, May 3, 2017 at 11:08 PM, Prabeesh K. <[email protected]> >> wrote: >> >>> 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. >>>>> >>>>> >>>>> >>>> >>> >> >
