Is there a way to update the scheduled query notification email to something custom?
By default it is the email of the creator, however, this is often a service account with no true email recipient.
e.g with terraform provisioning, we would have a service account. We would want to update the email notification target from the SA to a support email so failures would be routed more correctly?
Ive checked the documentation and I could be missing it, but does not seem an option, unless Ive missed something via the CLI?
Thanks!
Since scheduled Query IDs always start with "scheduled_query_[runsID]", search for scheduled_query_ using advanced logs queries
Create a logs-based metric based on your BigQuery scheduled update log.
Create an alerting policy using the logs-based metric created in step 1.
While creating the alerting policy in step 3, select email as a notification channel.
In notification channel, add your email address to get all the notifications.