Hi Prabeesh,
I believe to read from a sheet you have to use a fromQuery("SELECT * FROM
[sheet]"). This is because federated tables are really views and cannot be
exported to GCS directly.
On Thu, May 18, 2017 at 6:18 PM, Chamikara Jayalath <[email protected]>
wrote:
> I haven't tried reading BQ tables backed by Google sheets but this error
> seems to be coming from BigQuery. Could you try contacting BQ support
> channels ?
>
> Thanks,
> Cham
>
> On Thu, May 18, 2017 at 5:26 AM Prabeesh K. <[email protected]> wrote:
>
>> 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.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
