Re: Read from a Google Sheet based BigQuery table - Python SDK

2018-06-06 Thread Chamikara Jayalath
t; *Inviato:* martedì 5 giugno 2018 19:26 > *A:* u...@beam.apache.org > *Cc:* dev@beam.apache.org > *Oggetto:* Re: Read from a Google Sheet based BigQuery table - Python SDK > > > > See following regarding authenticating Dataflow jobs. > > https://cloud.google.com/dataflow/security-and

Re: Read from a Google Sheet based BigQuery table - Python SDK

2018-06-05 Thread Chamikara Jayalath
See following regarding authenticating Dataflow jobs. https://cloud.google.com/dataflow/security-and-permissions I'm not sure about information specific to sheets, seems like there's some info in following. https://cloud.google.com/bigquery/external-data-drive On Tue, Jun 5, 2018 at 10:16 AM Leon

Re: Read from a Google Sheet based BigQuery table - Python SDK

2018-06-05 Thread Chamikara Jayalath
I don't think BQ federated tables support export jobs so reading directly from such tables likely will not work. But reading using a query should work if your job is authenticated properly (I haven't tested this). - Cham On Tue, Jun 5, 2018, 5:56 AM Leonardo Biagioli wrote: > Hi guys, > > jus

Read from a Google Sheet based BigQuery table - Python SDK

2018-06-05 Thread Leonardo Biagioli
Hi guys, just wanted to ask you if there is a chance to read from a Sheet based BigQuery table from a Beam pipeline running on Dataflow... I usually specify additional scopes to use through the authentication when running simple Python code to do the same, but I wasn't able to find a reference t