Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Alerting or a Dashboard on long running query/jobs in big query

I would like setup and alert for long running queries/jobs lets if running beyond a threshold of 10 minutes.

 

How we can filter logs to find the required informations for long running jobs such as calculating differences of query start time and end times, duration, status.

 

No google defined metrics are present for this requirement.

0 7 132
7 REPLIES 7