GCS Egress Quota Use Ratio - MQL

egress_quota_use_alerting_policy.mql

fetch consumer_quota
| filter resource.service == 'storage.googleapis.com'
| { metric serviceruntime.googleapis.com/quota/rate/net_usage
    | align rate(1m)
    | group_by [resource.project_id, metric.quota_metric, resource.location],
        sum(value.net_usage)
    | cast_units('1')
  ; metric serviceruntime.googleapis.com/quota/limit
    | filter metric.limit_name == 'GoogleEgressBandwidth'
    | group_by [resource.project_id, metric.quota_metric, resource.location],
        sliding(1m), max(val()) }
| ratio
| every 1m
| condition gt(val(), 0.8 '1')

egress_quota_use_ratio_metric.mql

fetch consumer_quota
| { metric serviceruntime.googleapis.com/quota/rate/net_usage
    | filter
    (metric.quota_metric == 'storage.googleapis.com/google_egress_bandwidth')
    | align rate(1m)
    | every 1m
    | group_by [resource.location], [value_net_usage_max: max(value.net_usage)]
  ; metric serviceruntime.googleapis.com/quota/limit
    | filter metric.limit_name == 'GoogleEgressBandwidth'
    | group_by 1m, [value_limit_mean: mean(value.limit)]
    | every 1m
    | group_by [resource.location], [value_limit_mean_max: max(value_limit_mean)] }
| ratio
| every 1m