Sample Use Case - Service (BigQuery) to Service (GCS) copying of data

  1. BigQuery has a scheduled Query feature that is able to call PubSub on completion. When new data is available in Bigquery, the default SA for BigQuery is able to write to a pub sub topic.
  2. The function triggers a call to a pub sub topic.
  3. The pub sub triggers another cloud function which copies data from BigQuery to GCS.