CODEWITHSUNDEEP
google-bigquerygoogle-cloud-functions
user10310607
user10310607

Reputation:

Bigquery cloud function

Is it possible to create a cloud function with a dataflow script that goes from BigQuery back to BigQuery. Our main table is huge and has multiple nested fields which breaks the extract capabilities. We would like to create multiple simple tables that can be extracted containing all the relevant information for visualization. Query should execute only if there is a change in Main table.

Upvotes: 0

Views: 620

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173190

Cloud Functions does not support [yet hopefully] triggers based on BigQuery events

As of today, Cloud Functions supports the following native trigger mechanisms:

  • HTTP Triggers
  • Cloud Pub/Sub Triggers
  • Cloud Storage Triggers
  • Direct Triggers
  • Cloud Firestore
  • Analytics for Firebase
  • Realtime Database

see more at Calling Cloud Functions

Upvotes: 2

Related Questions