How to generate email alerts based on data issues in Bigquery table

516 Views Asked by At

I would like to see if any abnormal data loading issues in Bigquery tables through alerts based on some rules, Any possibility to do that with cloud logging and alert policies ?

1

There are 1 best solutions below

1
On

Your question is a bit unclear, are you looking for notifications about the table itself (load times / size etc) or what is in the table (the data)?

For what the table itself has already answered it here BigQuery - Scheduled Query Update Notification Email

If its what is in the table you are better off using python to automate this, there are plenty of tutorials about how to link BigQuery to Python and automate it and below is a similar query that should point you on the right track for automating an email from a condition How to send email alert through python if a string is found in a csv file?.