It doesn't look like BigQuery supports exporting to Google sheet[1], maybe you can invoke this BQ connector directly by adding a transform that follows the BQ sink.
1: https://cloud.google.com/bigquery/docs/exporting-data#export_limitations On Sat, Jun 6, 2020 at 8:31 PM OrielResearch Eila Arich-Landkof < e...@orielresearch.org> wrote: > Hello, > > Is it possible to have the pipeline sink to a google sheet within a > specific google drive directory. > Something like that: > > p = beam.Pipeline(options=options) > (p | 'Step 1: read file ' >> beam.io.ReadFromText(path/to/file) > | 'Step 2: process data ' >> beam.ParDo(get_daata(l])) > | 'step 3: write data to gsheet ' >> beam.io.WriteToXXX(GSHEET PATH)) > > > I know that BQ has a connector to Google sheet. Is it possible to use this > connector from the BQ sink? Other way? > > Thanks, > Eila > >
