'How to create a trigger for BigQuery on GCP and read the inserted value?
I saw a few articles around (e.g. https://cloud.google.com/blog/topics/developers-practitioners/how-trigger-cloud-run-actions-bigquery-events) that show how to create a "trigger" for BigQuery that activates Cloud Run (or a Cloud Function etc) using Cloud Logging to get notification that something has changed down to a BigQuery table. However how can I actually discover which values have been added to a table after an insert? For example if this happens on BQ:
insert into mydataset.mytable (name, surname, age) values ('John','Smith',30)
how can I discover from Cloud Run or a Cloud Function that the values 'John','Smith',30 have been actually added to the table mydataset.mytable?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|