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