This is my first question here, so I'm trying to do all politely :)
I have a table in BigQuery, where data is inserted every day. The insertion time is different every day, some days is 5 minutes later but other days can be 2 hours later.
After that, I have to execute a cloud function, which, at the moment, is scheduled with a cron (Cloud Scheduler --> Pub/Sub).
I want to execute the cloud function just after the insertion of data in my table. Do you have any tips?
I have tried with Eventarc and 2nd generation Cloud Functions. Using this trigger: google.cloud.bigquery.v2.TableService.InsertTable, but it doesn't work.
Do you have any idea? Thanks, Daniel